Thanks dear it works !! I had to recreate all database tables and restart my django server.
Thanks agian Karen.. you rock :) Regards, On Sep 29, 5:22 pm, Karen Tracey <kmtra...@gmail.com> wrote: > 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 -~----------~----~----~----~------~----~------~--~---
