I have this error String or binary data would be truncated

Question

Hi all
I have this error String or binary data would be truncated
when execute query insert, update multiple line data into table with column has type data ntext & text.
I get text from CKEditor control asp.net 2.0 and execute by GUI web form, this control to post comment has not tag code so I can not post my code

Please help me process this error

Thanks so much

Sam Hobbs · Answer

I understand that you cannot post code but you do have to be more specific unless I or someone can guess. I prefer to avoid guessing because then the person says I am wrong as if I should have known it was not what htey needed. My guess is that the field in the database is too small for the data that you are trying to put into it. It might be that there are just trailing spaces and if so then you are not likely to see the problem if the only thing you look at is the data. You need to look at the problem. What does the data look like that is causing the problem? How big is it? How big is the field in the database?