Maximum length for nvarchar in SQL2000

Hi,

I am using SQLSERVER2000.

When storing data in to database ,it is taking/storing only 255 characters for all the datatypes like nvarchar,nchar,char,ntext,text, etc...

I need to increase the maximum length of a field which takes 1000 characters & more.

I already increased the field length to 2000, but it is taking/storing only 255 characters.

Please help me in this............

It sounds like the parameters in your data access code are set to 255. Try checking them.

|||

I put 2000 characters for the parameter in the access code also.

|||

Why don't you post the client-side code you are using? Somewhere the data is being truncated, we just have to find out where.

Don