Another possible solution (and probably better one) is to use init_command option set to 'SET NAMES utf8'.
2008/9/18 Fedor Tyurin <[EMAIL PROTECTED]> > I set default-character-set to cp1251 (default server encoding) and now > admin seems to work correctly > > 2008/9/18 Fedor Tyurin <[EMAIL PROTECTED]> > > It seems to be related with database connection properties. I've tried with >> sqlite3 and problem disappeared. >> >> If I run mysql console and request status (\s command) mysql response the >> following information about character set: >> Server characterset: cp1251 >> Db characterset: utf8 >> Client characterset: cp1251 >> Conn. characterset: cp1251 >> >> I've also tried to set DATABASE_OPTIONS, but I don't know how to change >> connection and results character set from configuration file (only by using >> SET NAMES 'utf8'). >> >> Any help will be useful. Unfortunately I can't change mysqld settings, >> because it is on the web hosting provider's side. >> >> 2008/9/17 Fedya <[EMAIL PROTECTED]> >> >> Hi everybody, >>> >>> I'm trying to port my site to Django 1.0... And it works fine if >>> LANGUAGE_CODE is set to en-us, but if I set it to ru the following >>> problem appears while I'm trying add new object using admin interface: >>> >>> Warning at /admin/storage/file/add/ >>> >>> Data truncated for column 'message' at row 1 >>> >>> Request Method: POST >>> Request URL: http://test.legalsw.ru/admin/storage/file/add/ >>> Exception Type: Warning >>> Exception Value: >>> >>> Data truncated for column 'message' at row 1 >>> >>> Exception Location: /usr/lib/python2.4/warnings.py in warn_explicit, >>> line 96 >>> Python Executable: /usr/bin/python >>> Python Version: 2.4.4 >>> Python Path: ['/home/l/legalswru/test/public_html', '/home/l/ >>> legalswru/test/public_html', '/usr/lib/python24.zip', '/usr/lib/ >>> python2.4', '/usr/lib/python2.4/plat-linux2', '/usr/lib/python2.4/lib- >>> tk', '/usr/lib/python2.4/lib-dynload', '/usr/lib/portage/pym', '/usr/ >>> lib/python2.4/site-packages', '/usr/lib/python2.4/site-packages/PIL'] >>> Server time: Ср, 17 Сен 2008 14:56:13 -0500 >>> >>> I'm using MySQL database and it configured to use UTF8_BIN collation. >>> >> >> > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/django-users?hl=en -~----------~----~----~----~------~----~------~--~---