Sunday, March 11, 2012

Database Row Size Limit

Hi, All,

I came cross a problem like this.

Cannot create a row of size which is greater than the allowable maximum of 8060

Is there any method to solve this ?

This is by design, determined by data page size 8KB. Do you really need such a large row? You can put large columns like VARCHAR(8000) into TEXT columns.

No comments:

Post a Comment