iain duncan schrieb: > >> The MySQL database URLs require charset=utf8 as well: >> >> > sqlalchemy.dburi="mysql://web:password/momcafe_dev?charset=utf8" >> >> The driver doesn't seem to detect the connection character set well and >> needs a hint. From the traceback, it looks like the driver thinks the >> connection should be ascii. > > Adding the charset argument gives me the following error on start up: > > File > "/usr/lib/python2.4/site-packages/SQLAlchemy-0.4.2p3-py2.4.egg/sqlalchemy/engine/strategies.py", > line 80, in connect > raise exceptions.DBAPIError.instance(None, None, e) > sqlalchemy.exceptions.DBAPIError: (TypeError) 'charset' is an invalid > keyword argument for this function None None > > Is there another way to set that up somewhere?
Use SET NAMES 'utf8' after you created a connection, or before using one. I admit that's rather ugly - but it works. Diez --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
