Help with types in Sql SErver

8 Jul 2005 11:48 AM

Oscar

hi
I´ve got a field in a table defined as type nvarchar(1000) in a bbdd Sql
Server 2000

When i insert characters in this field, i can see only the first 255
charactes or 256 character
I know then type nvarchar can store 4000 characters. So ¿What can be happen?

I tried to change this field type to TEXT, but i have a problem with a
trigger after insert in this table, because, i need to have a history of
this table in bbdd.
So, can anybody help me?
Thanks

8 Jul 2005 11:51 AM

Tibor Karaszi

Do you look at the data using Query Analyzer? If so, it is pre-configured to only show < 255
characters. Change using Tools, Options.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/

Show quote

"Oscar" <oscgon***@hotmail.com> wrote in message news:eq$fAL7gFHA.1412@TK2MSFTNGP09.phx.gbl...
> hi
> I´ve got a field in a table defined as type nvarchar(1000) in a bbdd Sql Server 2000
>
> When i insert characters in this field, i can see only the first 255 charactes or 256 character
> I know then type nvarchar can store 4000 characters. So ¿What can be happen?
>
> I tried to change this field type to TEXT, but i have a problem with a trigger after insert in
> this table, because, i need to have a history of this table in bbdd.
> So, can anybody help me?
> Thanks
>
>
>

8 Jul 2005 1:37 PM

JosephPruiett

Go to tools->options->results tab in QA and change the maximun char to view
from 255 to 1000 or so you dont have to keep the changes you made by changing
it to text unless you might have more than 1000 char inserted into that
column. In that case you would want to keep as text.

Hope this helps.

Show quote

"Oscar" wrote:

> hi
> IÂ´ve got a field in a table defined as type nvarchar(1000) in a bbdd Sql
> Server 2000
>
> When i insert characters in this field, i can see only the first 255
> charactes or 256 character
> I know then type nvarchar can store 4000 characters. So Â¿What can be happen?
>
> I tried to change this field type to TEXT, but i have a problem with a
> trigger after insert in this table, because, i need to have a history of
> this table in bbdd.
> So, can anybody help me?
> Thanks
>
>
>
>