When you designed your database you may have selected TEXT because of its flexibility of size instead of a, say, a VARCHAR data type. If you ever thought you would store a text bigger than 65Kb on your TEXT columns and you started to having your strings cut, then you have reached the limit of TEXT var type in MySQL, and ACHTUNG! it will not complaint about this but silently truncate your data!
In bytes this limit is 65535 (2^16 - 1), which is, BTW, a Mersenne Number.
In this case consider using MEDIUMTEXT or LONGTEXT.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment