On 5/27/06, Joris <[EMAIL PROTECTED]> wrote: > However, porting to a mysql db proved to be more troublesome. First > sqlobject created tables with charsets different from the database default > (could be mysql/sqlobject/python/os default). My database default is UTF-8 > btw.
Usually the solution to this problem (when using py-mysql directly) is to pass this as the first command during your MySQL session: set names utf8 That sets a number of encoding parameters, including the encoding of the connection itself. (Here's a reference to the same problem: http://tahpot.blogspot.com/2005/06/mysql-and-python-and-unicode.html) I'm not sure how to do that with SQLObject in the way, though. --Liza --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
