Sunday, February 19, 2012

error while saving in text datatype

HI,

I've a table with 5 fields datatype as text. I get error like this when i save huge data (like letter format)

String or binary data would be truncated.
The statement has been terminated.

Is text a better datatype to store huge data. What are the problems i might get with this. is there any other better datatype other than varchar(8000).

thanks

venp--

HI,

I'm planning to try with varchar(max) datatype.

venp--

No comments:

Post a Comment