My local system is with sql 2005,one 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 fine,but 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
Loading
Suthish NairPosted Jan 21, 2011, 5:51 AM
SQL Server 2008 supports two data types nvarchar(MAX) and nvarchar(50).
So you need to use nvarchar(MAX).
Vijay YadavPosted Jan 20, 2011, 8:15 AM
Just check on your server whther the datatype is nvarchar(200) or not and if yest then use alternative varchar(200).
Thanks,
Vijay
George OnofreiPosted Jan 13, 2011, 7:28 AM