Data truncated for column 'message' at row 1

[p.patruno@…]

if I set LANGUAGE_CODE = it_it in settings.py and use admin interface to change some data in my tables the result is:

Exception Type: Warning
Exception Value: Data truncated for column 'message' at row 1
Exception Location: /usr/lib/python2.5/warnings.py in warn_explicit, line 102

168. if not self._defer_warnings: self._warning_check() ...

▼ Local vars
Variable Value
ListType <type 'list'>
TupleType <type 'tuple'>
args [1L, u'program "mandami" \xe8 stato modificato correttamente.']
charset u'utf8'
db <weakproxy at 0x8755c5c to Connection at 0x87a7634>
exc_info <built-in function exc_info>
query u'INSERT INTO auth_message (user_id,message) VALUES (1,\'program
"mandami
" \xe8 stato modificato correttamente.\')'
r 1L
self <MySQLdb.cursors.Cursor object at 0x87648ec>

All is right with LANGUAGE_CODE = en_us

I use mysql and if I execute this sql
INSERT INTO auth_message (user_id,message) VALUES (1,\'program
"mandami
" \xe8 stato modificato correttamente.\')
I get an error

If I execute this sql all works right:
INSERT INTO auth_message (user_id,message) VALUES (1,'program
"mandami
" \xe8 stato modificato correttamente.')

thanks

Paolo Patruno

[Simon G. <dev@…>]

Paolo, what version of Django are you using? these things should all be fixed since the unicode merge (this looks like a duplicate of #4336 too).

[p.patruno@…]

I use Fedora 7 but Django is svn trunk version of Sat Jul 21 repackaged in rpm with the same spec file.

Paolo Patruno

[Simon G. <dev@…>]

yeah, that sounds like the bug in #4336.

[Pedro Lima]

Could it be an old connector? Try changing to mysql_old (see ​here)