Friday, February 24, 2012

Help me solve this.

When I collect data from a form, I recieved this message:

"Cannot create a row of size 8822 which is greater than the allowable maximum of 8060. The statement has been terminated."

Can any body tell me how to solve this, my data field is varchar size 8000 bytes, and I posted only ~ 6000 byte.Show the entire table definition, and perhaps we can help.|||There are several data types that store a fixed amount of data. For example, a char (10) field will store 10 bytes even if you never assign a value to it. So, if you have 4000 bytes worth of fixed-length fields, and you put 6000 bytes into a varchar(8000) field, you would end up with a record that's 10000 bytes and the update wil fail.

No comments:

Post a Comment