Problem with nvarchar in MS SQL Server 2000

Rails
1

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

2

Hi,

I still have the problem: I can`t save more than 255 Characters in an
SQL-Server nvachchar -Field, although MS SQL Query Analyzer says, this
field has a length of 510 characters.

I got a newer ADO.rb File, but it didn`t solve the problem.

Maybe it has something to do with unicode.

Any suggestions?

Thank you

Thorsten

3

On 6/30/06, Thorsten Brückner [email protected] wrote:

Rails mailing list
[email protected]
http://lists.rubyonrails.org/mailman/listinfo/rails

I’m using sql 2000 w/ Rails. Post your error and offending code and
data.

4

I would suspect unicode issue. Can you store 512 chars in a varchar(512)
field?

Raf

5

Hello,

MS SQL Server Query Analyzer says I can store 510 characters in
nvarchar;

But the MS SQL Server Enterprise Manager says, nvarchar field only can
store 255 Characters.

I think that was the problem; i will try it with an text-column.

Thank you

Thorsten

Rafael S. wrote:

I would suspect unicode issue. Can you store 512 chars in a varchar(512)
field?

Raf