nvarchar problen in sql 2005 & sql 2008

Question

My local system is with sql 2005one field in a table declare as nvarchar(200)But the server supports sql 2008.When i upload any data in this field it stores only 50 charactors.Locally it runs finebut on-line not.Locally nvarchar(200) stores 200 characters but on-line it stores only 50 characters Suggest me. Thanks in ad. With regards Naveen Verma

Suthish Nair · Answer

Yes Naveen you are right. SQL Server 2008 supports two data types nvarchar(MAX) and nvarchar(50). So you need to use nvarchar(MAX) .

Vijay Yadav · Answer

Hi Naveen Just check on your server whther the datatype is nvarchar(200) or not and if yest then use alternative varchar(200). Thanks Vijay

George Onofrei · Answer

try varchar(MAX). Might work.