varchar can only hold 4000 bytes
and there is no text column in sql server mobile
Hi,
try 'ntext'
Pete
|||I'm using SQL CE 3.5 with VS 2008 Beta 2:I have a table with some coulmns of NTEXT type, but when i want to update my dataset to database with a row which has that field more than 4000 charachters I got this error:
"InvalidOperationException was unhandled
@.p4 : String truncation: max=4000, len=4374
...."
Regards,
Parham.
|||NTEXT should accept 536870911 charachters! But why iam getting that Error?!
|||
It is probably a problem with the DataSet designer. Check the designer generated code, and you may find that it has limited the @.p4 length to 4000. You can probably manually change this.
|||I'm having the same issue. I checked through the designer code and found the max length set to the correct length for ntext (536870911). Just to be sure I recreated the database and the dataset, but got the same result. I think this might be a genuine bug.