Sunday, December 4, 2011

MYSQL5.1 Row size too large

The detail description as following:
"MySQL Database Error: Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. You have to change some columns to TEXT or BLOBs "

main reasons as following:
1)MYSQL VARCHAR length limit is
65535 bytes,if you use UTF8,the length limit is 65535/3.

2)mysql5.1 bug,the bug is http://bugs.mysql.com/bug.php?id=50495
please upgrade the MYSQL version to 5.1.47



No comments:

Post a Comment