is it posible to put more than 4000 bytes into one column? ( sql server mobile )

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.