Rails - Jun 2006 - Problem with nvarchar in MS SQL Server 2000

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/.

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

-- 
Posted via http://www.ruby-forum.com/.

On 6/30/06, Thorsten Br?ckner <tbrueckner@newyorkcity.com>
wrote:
>
> 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
>
> --
> Posted via http://www.ruby-forum.com/.
> _______________________________________________
> Rails mailing list
> Rails@lists.rubyonrails.org
> http://lists.rubyonrails.org/mailman/listinfo/rails
>
I''m using sql 2000 w/ Rails.  Post your error and offending code and
data.

-- 
------------------------------
Apple MacBook.  Black.  It''s the new White!
------------------------------
Peter Fitzgibbons
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://wrath.rubyonrails.org/pipermail/rails/attachments/20060630/ee34a877/attachment.html

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

Raf

-- 
http://www.bdcsoftware.com" - Automotive CRM

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 Szuminski wrote:
> I would suspect unicode issue. Can you store 512 chars in a varchar(512) 
> field?
> 
> Raf

-- 
Posted via http://www.ruby-forum.com/.