65K length limitation in MySQLdb?
TT
vtians at gmail.com
Mon Jun 9 21:14:22 EDT 2008
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
import MySQLdb
import MySQLdb.cursors
class MyDb:
def __init__(self):
self.conn = None
self.cursor = None
def connect(self):
self.conn = MySQLdb.Connect(
host='localhost', user='user',
passwd='password', db='testdb',compress=1,
cursorclass=MySQLdb.cursors.DictCursor)
self.cursor = self.conn.cursor()
def insert(self, id, content):
try:
self.cursor.execute("INSERT INTO `my_table`(`id`,
`content`) VALUES (%s, %s);", (id, content));
except:
print "Failed to insert new record"
pass
More information about the Python-list
mailing list