The value violates the MaxLength limit of this column.

[bahram]

pleas help me

vs.net2005
i have textbox that binding to dataset table1.name
my database in sqlserver 2000,my lenght name= 100 and nchar
but i update sqldataadapter e error ecord The value violates the MaxLength limit of this column. please help me
what error happen my lenght is 50 and my input 20 error what happen

 

[kulrom]

change the field datatype to nvarchar or text and try again. What's happening there is probably that you want to store large amounts of Unicode data which is considered in a different way than ASCII characters are. Means 20 unicode characters are not same as 20 ASCII characters.
Regards

 

[bahram]

thanks my freind