Funny, I discussed this same problem on IRC on the sqlalchemy channel the other day, the solution was to add the options charset=utf8 and use_unicode=0 to sqlalchemy.url, then force sqlalchemy to convert to unicode (this fixes Genshi problems), with the option sqlalchemy.convert_unicode = True.
The problem seems to be mysqldb connector, it has problems when working with unicode, setting it explicitly to use utf8 helps to keeping it from converting to ascii, and then you need to force mysqldb to not use it's internal unicode functions (they have problems, leaks, exceptions and whatnot), it will return a bytecode string, which with genshi it gives trouble as is not a regular string, you' ll need to convert it to unicode (something genshi can work with) with something else, sqlalchemy can do the work for you, adding the option convert_unicode. It was a blast drilling though the documentation, mailing list, traceback and code to find this. Bottom line, use another DB with a proper DBAPI driver or use another driver for MySQL. Regards, Carlos Daniel Ruvalcaba Valenzuela -- 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.
