On 2006-11-14 13:59, Robin Haswell wrote:
> > test data (edited via phpMyAdmin):
>
> If this means "I put in my test data with phpMyAdmin", then I'd guess
> there's your trouble. PHP doesn't support Unicode, MySQL doesn't
> support Unicode, and in my experience PMA's unicode-awareness is
> patchy. I'd say PMA has caused your unicode problem.

Tnx, Rob, for this idea.

Both, PMA and MySQL, support Unicode.

Today I solved it using the 0.3.1 update from SQLAlchemy, where Mike 
Bayer made is possible to pass over some additional custom DBAPI 
connect arguments:
http://www.sqlalchemy.org/docs/dbengine.myt#dbengine_establishing_custom

I found out, that MySQLdb need use_unicode=True during database 
connection.

So I simply put into my dev.cnf
sqlalchemy.dburi="mysql://user:[EMAIL PROTECTED]/database?use_unicode=1"
and that's it.

Cool!

Ciao,
Stefan

-- 
Start here: www.meretz.de

--~--~---------~--~----~------------~-------~--~----~
 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
-~----------~----~----~----~------~----~------~--~---

Reply via email to