Thanks to all for the help. I simply replaced one file, adapter.py, with the new version and everything worked fine.
--- Dmitry Vasiliev <[EMAIL PROTECTED]> wrote: > Stephen Day wrote: > > Hello, > > > > I'm trying to access a MySQL database through > Zope3 > > but I keep getting an error about encoding: > > > > "LookupError: unknown encoding: latin1_swedish_ci" > > > > > I've tried changing the encoding of the database > and > > the Zope connection object to utf8, among other > > things, but nothing seems to work. > > > > I'm using MySQL 4.1.14-nt, Zope-3.1.0c1 with > > mysqldbda-1.0.0 installed, and Python 2.4.1. > > > > I am able to connect to the database sucessfully > afaik > > because the USE statement seems to work (i.e., > there > > is no error). One thing I am wondering is if the > > database adapter was installed correctly... all I > did > > was copy the mysqldbda directory to > > C:\zopeinstance\lib\python and then added the file > > mysqldbda-configure.zcml to > > C:\zopeinstance\etc\package-includes. > > > > Any ideas? > > The problem seems that the adapter use > connection.character_set_name()... Try > use Zope-3.1.0c2 and mysqldbda from svn trunk > http://svn.zope.org/mysqldbda/trunk/ then you can > set connection encoding manually. > > -- > Dmitry Vasiliev (dima at hlabs.spb.ru) > http://hlabs.spb.ru > _______________________________________________ Zope3-users mailing list Zope3email@example.com http://mail.zope.org/mailman/listinfo/zope3-users