[BUG] ActiveRecord woes with SQL Server odd names (spaces and brackets), ntext data types
ActiveRecord (latest versions of ODBC, DBI, and AR as of today
2005-12-01) seems to be having trouble with at least two things that
SQL Server 7 does:
1. The SQL Server adaptor (sqlserver_adaptor.rb) get_table_name sub
expects a name to have no whitespace in it. The conditional and
regex need to be changed to look for bracketed names like [Poorly
Designed Table]. Then, the columns sub needs to know to take the
brackets off the ends of the names when it looks up the table by its
textual value. To complicate this, according to
http://msdn2.microsoft.com/en-us/library/ms176027.aspx you can have
either double-quotes or square brackets as your delimiters in SQL
Server names, and you can even escape brackets by doubling. I
have written hackish code that solves for simple [Dumb Name] tables but
not the whole enchilada, so I’m not posting it here yet.
2. The data type “ntext” seems to create memory allocation problems; I get an error of:
/usr/lib/ruby/site_ruby/1.8/DBD/ODBC/ODBC.rb:220:in `fetch’: failed to allocate memory (NoMemoryError)
Running this on CYGWIN_NT-5.1 RANDALL-VAIO 1.5.19s(0.141/4/2) 20051102 13:29:13 i686 unknown unknown Cygwin on Win XP Pro.