> From the error there, the data in the database may not be utf-8. > '\xe9' is the byte sequence for é in latin-1, not in utf-8. > > If you can retrieve the data from the database and look at it in a hex editor > and it has the byte sequence 0xe9 there then the problem is the data stored > in the db. If you retrieve it that way and the hex sequence is 0xc3 0xa9 > then the data in the database is correct and somewhere in the mysql python > bindings or sqlalchemy the data is going through a series of decode and > encode operations that result in it being encoded as latin-1 instead of > utf-8.
Thank you very much for a response! S a i n t - E x u p r y 53 61 69 6e 74 2d 45 78 75 70 c3 a9 72 79 0xc3 0xa9 in the database as viewed in a hex editor. As I understand it the database is correct. Where do I go from here? mysql python people? sqlalchemy people? What else can I do to make sure this isn't my code, my database? Thanks. -- You received this message because you are subscribed to the Google Groups "TurboGears" 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/turbogears?hl=en.
