Re: Django charset problem

2009-07-20 Thread Andrew Fong
Well, you already set the character set correctly on the database, so thing should just work now. If it's not, you probably just need to restart MySQL. Lemme know if you're still having trouble. -- Andrew On Jul 20, 6:58 pm, Larry wrote: > Hi Andrew, > > Thank you very

Re: Django charset problem

2009-07-20 Thread Larry
Hi Andrew, Thank you very much. I have changed the settings as you said. Just one more question: for the tables and databases that I already have, is there any way in which I can make changes in place so that things will look right? I want to do this because the tables I have are quite large and

Re: Django charset problem

2009-07-20 Thread Andrew Fong
Yeah, that output doesn't look correct. You're getting back two characters for ø when there should be just one. One possibility is that while you've set up the database server to store things as utf8, the client hasn't been set to read them. You can do this manually from the client, but if you

Re: Django charset problem

2009-07-20 Thread Larry
HI Andrew, Thanks for your reply. I tried it via Django's shell, one message which appears "Isbjørn" in the MySQL client is displayed as "Isbj\xc3\xb8rn" in the Django shell. Is this normal or there is already something wrong? The way I configure MySQL is that I use some parameters when

Re: Django charset problem

2009-07-17 Thread Andrew Fong
Try fetching the data via Django's shell. What do you get then? Also, how did you configure MySQL to work with UTF-8? Did you modify your my.cnf file so UTF-8 is the default? Or did you change your database's settings manually? Or something else? -- Andrew On Jul 17, 5:33 pm, Larry

Django charset problem

2009-07-17 Thread Larry
Hi, I have a database with messages stored and utf-8 encoded. The messages look OK in the database, i.e, when I am in MySQL client the messages with special characters (e.g., Korean) are correctly displayed. However, in the web page, the special characters become irrecognizable, like this