String or binary data would be truncated.

[Suku]

Hi ...I am getting this error and the column that I am insertig into is of varchar type with max length of 4000.

Can I change this to nvarchar type of 8000 in the table design.

I wanted to be sure that it wont affect the data in any way.

Can anyone help me with this ....

[Jim Steiner]

Since you are extending the size of the field it won't be an issue.


------------
Suku at 5/21/2002 2:52:53 PM

Hi ...I am getting this error and the column that I am insertig into is of varchar type with max length of 4000.

Can I change this to nvarchar type of 8000 in the table design.

I wanted to be sure that it wont affect the data in any way.

Can anyone help me with this ....

[Carl]

Keep in mind that there is an 8000 char limit per row on tables, ie, the sum of all the definitions of all columns in a table cannot add up to more than 8000. If you truly must have a field that large, consider making it a TEXT field. However, that can have performance implications.

Cheerio!


------------
Jim Steiner at 5/21/2002 3:50:45 PM

Since you are extending the size of the field it won't be an issue.


------------
Suku at 5/21/2002 2:52:53 PM

Hi ...I am getting this error and the column that I am insertig into is of varchar type with max length of 4000.

Can I change this to nvarchar type of 8000 in the table design.

I wanted to be sure that it wont affect the data in any way.

Can anyone help me with this ....