On 12/11/06, Georgi Stanojevski <[EMAIL PROTECTED]> wrote: > > > Anton Daneika напиша: > > > playing with example polls application. This resulted in a bunch of > question > > marks on the view page, instead of the expected "Как дела?" poll > question, > > which was in Cyrillic. > > My firefox character encoding is set to UTF-8; > > the following command: > > $ env | grep -i utf > > yields to > > LANG=en_AU.UTF-8 > > > > Has anyone faced that problem before? > > Am I supposed to switch something else in django or MySQL to get the > > cyrillic text or am I doing something stupid? > > Which mysql version are you using?
$ mysql --version mysql Ver 14.12 Distrib 5.0.22, for pc-linux-gnu (i486) using readline 5.1 I'm using mysql 5.0.24a and django from svn - utf-8 cyrillic text works > fine out of the box in a browser with a default codepage of utf-8. The > system locale is mk_MK.utf8. I use Django 0.95 official version To get mysql client in the console working with utf-8 (doesn't have > anything to do with Django) I have this in /etc/my.cnf: > > [client] > . > . > default-character-set = utf8 > > [mysqld] > . > . > character-set-server=utf8 > collation-server=utf8_unicode_ci > init_connect='set collation_connection = utf8_unicode_ci;' Well, I tried this conf modification. Before it I could do mysql> insert into polls_poll (`question`, `pub_date`) values ('Часто ли у вас возникают проблемы с кирилицей?', NOW()); Then the select statement would produce a correct cyrillic output, but after the proposed conf modification I get garbled text in mysql client... --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---