In django I am using django-tinymce to create newsletter for my registered users. Content (which is HTMLField()) is in unicode and it is stored in my database (mysql) as unicode correctly.
I have this script to send the newsletter to all registered users (except those who have opted-out).
The problem is that unicode characters in the email message is shown as questionmarks (ie. ???????) What am I doing wrong?
PS: I also tried this
asked Oct 04 '12 at 06:53
It looks to me like you're not telling MySQLdb to use unicode. Try setting up your database connection like this:
If that doesn't work (or perhaps as an altogether better approach) you might try accessing your data via the Django model, since Django should handle the unicode stuff for you automatically. For example:
Hope that helps!