65K length limitation in MySQLdb?

Jarkko Torppa torppa at staff.megabaud.fi
Tue Jun 10 01:53:08 EDT 2008


On 2008-06-10, TT <vtians at gmail.com> wrote:
> I'm trying to using the following code insert a long string into a
> MySQL table, the data type is of that column is TEXT. When the length
> of the content is longer than 65K, it get truncated in the database.
> Any idea about this?  Thanks

It's limitation on your sql engine, use longtext.

http://dev.mysql.com/doc/refman/5.0/en/storage-requirements.html

-- 
Jarkko Torppa



More information about the Python-list mailing list