Netuality

Taming the big, bad, nasty websites

Tagged posts

Unicode in Python micro-recipe : from MySQL to webpage via Cheetah

Very easy:

start by adding the default-character-set=utf8 in your MySQL configuration file and restart the database server
apply this recipe from Activestate Python Cookbook (”guaranteed conversion to unicode or byte string”)
inside the Cheetah template, use the ReplaceNone filter:

#filter ReplaceNone
${myUnicodeString}
#end filter
in order to prevent escaping non-ASCII characters.

Now. That’s better.