On Tue, Sep 29, 2009 at 12:05 PM, Rizwan <br.riz...@googlemail.com> wrote:
> > Thanks for reply, I was suspecting this and I did change my database > charset to UTF-8. but still it giving me same error. > > What did you do exactly? ALTER DATABASE db_name CHARACTER SET UTF8? If so, that won't change existing tables, they'll still use the charset that was default when they were created. You can either manually convert them using the alter table I mentioned earlier or recreate them all. > Reagarding to database or server default charset, is there any setting > i need to specify in setting file or any where else? > > Since it looks like you are using Windows the server config file is likely named my.ini in your server's installation directory. If you created that config with the configure wizard it likely already has a default-character-set=latin1 in the [mysqld] section. That's what you want to change if you want the server to use utf8 for all new DBs and tables by default. Alternatively run through the configure wizard again and choose "Best Support for Multilingualism" instead of "Standard Character Set" on the page that asks for default character set. Karen --~--~---------~--~----~------------~-------~--~----~ 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 django-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/django-users?hl=en -~----------~----~----~----~------~----~------~--~---
