MySQLdb error for sql >64K

JZ cy.fbp.eryvtvne at ncbybtrglxn.pbz
Fri Apr 16 08:14:19 EDT 2004


I cannot execute insert data into TEXT field if that data is bigger than
64KB. :(

>>> cursor.execute("INSERT INTO table (field) VALUES(%s) WHERE id=1", myValue)

Traceback (most recent call last):
File "<interactive input>", line 1, in ?
File "C:\opt\PYTHON~1\lib\site-packages\MySQLdb\cursors.py", line 95, in
execute
    return self._execute(query, args)
File "C:\opt\PYTHON~1\lib\site-packages\MySQLdb\cursors.py", line 114, in
_execute
   self.errorhandler(self, exc, value)
File "C:\opt\PYTHON~1\lib\site-packages\MySQLdb\connections.py", line 33,
in defaulterrorhandler
   raise errorclass, errorvalue
Warning: Rows matched: 1  Changed: 0  Warnings: 1

The same sql query executed using MySQLFront client works without any
problems. So, I think the problem must be with MySQLdb 0.9.2 module.

Any suggestions?

--
JZ



More information about the Python-list mailing list