Django and MySQL utf8 encoding issue

Question

I have a database that uses a UTF-8 charset encoding. When I use the shell prompt to run mysql and select rows from tables, I can see the characters just fine (Frédéric Bélier). However, when running my django project and viewing a page in browser the field shows up as FrÃ©dÃ©ric BÃ©lier. The HTML page as a charset meta tag of UTF-8.

When opening my views file (and template file) in Gedit I see that the charset is set to UTF-8 as well. However, when I run file -i views.py the output is views.py: text/x-java; charset=us-ascii / ASCII Java program text, with CRLF line terminators.

Any advices on what can be wrong and how it can be fixed?

Django+MySQL: How To Fix Unicode (aka Mysterious Question Marks) - Standard Deviations -> parand.com/say/index.php/2008/06/11/… — Mohammad Efazati
– Mohammad Efazati, Commented Jan 29, 2012 at 6:59
I don't think that the encoding of your *.py files has anything to with it. — Sonia
– Sonia, Commented Jan 29, 2012 at 11:35
settings.DEFAULT_CHARSET is set to utf-8 and I tried adding "# -- coding: utf-8 --", with not much success... @Efazati - I already have these settings configured correctly as shown in that post. — Joel
– Joel, Commented Jan 29, 2012 at 11:43

Sonia · Accepted Answer · 2012-01-29 11:26:10Z

1

I am not a Django expert but perhaps it has something to do with a

HTTP Header or Document Header
A Django configuration. In Python a string is not necessarily unicode (unlike .NET for example)

My gut tells me that 2 in the probable situation.

answered Jan 29, 2012 at 11:26

Sonia

1,0542 gold badges13 silver badges22 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Django and MySQL utf8 encoding issue

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related