Hi,

Firstly - I'm hugely impressed with SQLAlchemy - it's really helped me
a lot with my new project.

I'm having problems storing international characters in mysql using
SQLAlchemy. For example:

  école—school

looks like this in mysql:

  école—school

I'm using the following engine call:

  engine = create_engine(config.db, encoding='utf-8')

and using Unicode as the column type:

  Column('content',       UnicodeText),

and utf8 for the table:

  mysql_charset='utf8'

I'm pretty sure all my mySQL options are set to utf8. This looks
really similar to a 'double encoding' issue I found while searching
the group, but it seems that was fixed in python-mysql 1.2.2, which is
what I'm using.

Any help would be much appreciated.

Joe
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"sqlalchemy" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to