Storing Data from richtextbox

  • Thread starter Thread starter Jim
  • Start date Start date
J

Jim

I'm inserting the value of richTextBox.RTF into a new row in a DataSet. The
update works with no problem but it's only storing a fraction of the RTF
value. The SQL2k datatype is set to varchar and MaxValue of 8000. But it's
not even storing more than 500 characters if a 1000 character variable.

What could the issue be? Is it a datype issue with the column in the
dataset?
 
After trying different angles, I got the following error trying to enter the
data into the DB directly through VS.Net:

"The Value you entered is not consistant with the datatype or length of the
column, or grid buffer limit."

Hmm, I wonder which one it could be. The Datatype is varchar and the length
is 8000. And the RTF I'm entering is 4200 characters long.
 
Jim said:
After trying different angles, I got the following error trying to enter the
data into the DB directly through VS.Net:

"The Value you entered is not consistant with the datatype or length of the
column, or grid buffer limit."

Hmm, I wonder which one it could be. The Datatype is varchar and the length
is 8000. And the RTF I'm entering is 4200 characters long.
Click to expand...

That's 4200 ***16-BIT UNICODE*** characters.
 
Back
Top