In MySql console client: ALTER TABLE tbl_name CONVERT TO CHARACTER SET utf-8; or ALTER TABLE t MODIFY latin1_text_col TEXT CHARACTER SET utf8;
for each table. or something like it. look to the manual - http://dev.mysql.com/doc/refman/5.0/en/alter-table.html http://dev.mysql.com/doc/refman/5.0/en/alter-database.html - this is usefull too, you can set default character table for whole db and new table will have proper character set my old solution was to kill whole dababase, modify my.sql string to "default-character-set=utf8" and recreate db, followed by "manage.py syncdb" :) On 19 июн, 14:34, "Ramdas S" <[EMAIL PROTECTED]> wrote: > Even I am facing the same problem. Any ideas how exactly do you set in MySQL > or does migrating PostGres solve it? > > Ramdas S > 2008/6/19 Vasiliy Gladkov <[EMAIL PROTECTED]>: > > > > > > > looks like you have to set character set in your database. as i > > remember, i had similar problem with my mysql, wich has non-utf-8 > > character set > > > On 19 июн, 04:23, "Keith Mallory" <[EMAIL PROTECTED]> wrote: > > > Hello, > > > > I am doing a small web site in django for my friend. > > > > The web site needs to have couple of dozen pages in chinese. > > > > What should I do in django to display these characters correctly? > > > > Most of them content needs to be updated. We have tools to create the > > > chinese text in unicode. We want the same to cut and paste onto the > > django > > > admin interface, and it should render correctly. > > > > We also have some feedback form which is using newforms modelform. Again > > if > > > someone types in Chinese unicode characters (cut and paste from an > > external > > > editor, it should generate). > > > > While in the text box the text displays correctly, after saving all I see > > is > > > > ??????????? > > > > I changed my settings in the browser and I am able to view other pages > > > correctly. > > > I tried the i18n documentation. It is of little help, despite me trying > > all > > > combinations. All help appreciated > > > > Many Thanks > > > > Keith Mallory > > -- > Ramdas S > +91 9342 583 065 > My Personal Blog:http://ramdas.diqtech.com --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
