# Problem with nvarchar in MS SQL Server 2000

**URL:** <https://www.ruby-forum.com/t/problem-with-nvarchar-in-ms-sql-server-2000/96403>\
**Category:** Rails\
**Created:** [June 28, 2006, 5:24pm UTC](https://www.ruby-forum.com/t/problem-with-nvarchar-in-ms-sql-server-2000/96403 "2006-06-28T17:24:27Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![shayu70](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/4bbf92/32.png) [@shayu70](https://www.ruby-forum.com/u/shayu70)\
**Post date:** [June 28, 2006, 5:24pm UTC](https://www.ruby-forum.com/t/problem-with-nvarchar-in-ms-sql-server-2000/96403/1 "2006-06-28T17:24:27Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![shayu70](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/4bbf92/32.png) [@shayu70](https://www.ruby-forum.com/u/shayu70)\
**Post date:** [June 30, 2006, 11:21am UTC](https://www.ruby-forum.com/t/problem-with-nvarchar-in-ms-sql-server-2000/96403/2 "2006-06-30T11:21:15Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![shayu70](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/4bbf92/32.png) [@shayu70](https://www.ruby-forum.com/u/shayu70)\
**Post date:** [June 30, 2006, 3:40pm UTC](https://www.ruby-forum.com/t/problem-with-nvarchar-in-ms-sql-server-2000/96403/3 "2006-06-30T15:40:59Z")

</div>

On 6/30/06, Thorsten Brückner [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) wrote:

> Rails mailing list  
> removed\_email\_address@domain.invalid  
> [http://lists.rubyonrails.org/mailman/listinfo/rails](http://lists.rubyonrails.org/mailman/listinfo/rails)

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

---

<div class="post-metadata">

**Author:** ![shayu70](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/4bbf92/32.png) [@shayu70](https://www.ruby-forum.com/u/shayu70)\
**Post date:** [June 30, 2006, 11:53pm UTC](https://www.ruby-forum.com/t/problem-with-nvarchar-in-ms-sql-server-2000/96403/4 "2006-06-30T23:53:11Z")

</div>

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

Raf

---

<div class="post-metadata">

**Author:** ![shayu70](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/4bbf92/32.png) [@shayu70](https://www.ruby-forum.com/u/shayu70)\
**Post date:** [July 3, 2006, 6:17pm UTC](https://www.ruby-forum.com/t/problem-with-nvarchar-in-ms-sql-server-2000/96403/5 "2006-07-03T18:17:04Z")

</div>

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