search for: nvarchar

Hello, after putting ADO.rb into Directory \ruby\lib\ruby\site_ruby\1.8\DBD\ADO\ I created a Rails-Application with MS SQL Server 2000 as Database. Everything works fine, but into the nvarchar-Field "notice" i can''t store more than about 50 or 60 characters MS SQL Server Query analyzer says, this field has a length of 510 characters. What can i do to save up to the 510 characters? Thank you Thorsten -- Posted via http://www.ruby-forum.com/.

I have installed active admin and also add my model -controller rate_professor there.......I can add/delete/edit data using active admin ...but if I click on submit button of my form in rate_professor controller ... I can see whatever I added in the index page ........but I don''t want to see that one.....I want to find the information(whatever I added by clicking submit button) on

...omatically generated rownames, even if: * the first column of the query is called rownames using "Select ... AS rownames, ... From ..." * and: the values from this column are unique * and: the values are inevitably forced to character data with e.g. " 'rn_' + CAST(xy AS NVARCHAR) " It works with sqlFetch but I would have to define a view for every query. Does anybody know help? SQL-Server: MS SQL 2000 ___________________ Markus Preisetanz Consultant Client Vela GmbH Albert-Roßhaupter-Str. 32 81369 München fon: +49 (0) 89 742 17-113 fa...

In order to coerce Rails 1.2.x into supporting Unicode values for an attribute in a model, I found I had to do the following: 1) Change the underlying column type from varchar to nvarchar. 2) Prepend any quoted values going into nvarchar columns with a capital-letter-N, e. g. ''unicode'' becomes N''unicode'' In order to accomplish this, I modified SQLServerAdapter#quote to look like this: def quote(value, column = nil) return value.qu...

...(DSN = "HIM") SQL Server ODBC driver (DSN = "HIMs") MS Access ODBC driver (DSN = "HIMa") Table (T304) being queried has ~290K rows, of which the query being run should return ~78K. Table being queried has 142 columns, of which all but 5 are type float. The other 5 are nvarchar(255) No indices or keys - one flat table No UPDATEs, INSERTs, just SELECT R code looks like this: him <- odbcConnect("HIM", "CDCS", "") FAC <- sqlQuery(him, "Select * from T304 where f133=1") If the DSN used points to SQL Server, the query seems to...