[Catalyst] UTF-8 strings getting stragely converted to latin1 when coming from MySQL DB

Michele Beltrame mb at italpro.net
Fri Mar 3 11:10:49 CET 2006


Hello Matt!

> __PACKAGE__->storage->on_connect_do([ "set names utf8" ]);
>
> to ensure this gets run immediately after the $dbh is (re-)connected.

At last I was able to migrate one of my Catalyst application to
DBIC::Schema. However, putting this query in the schema class does no
good for the UTF-8 thing.

How can I be sure it is executed? I tried replacing it with something
invalid such as "set nameddswgs utf8" (which returns an error in
mysqlclient), but I get no error in Catalyst. That's why I ask this
question. ;-)

	Thanks, Michele.

-- 
Michele Beltrame
http://www.varlogarthas.net/
ICQ# 76660101
Informativa privacy: http://www.italpro.net/em.html



More information about the Catalyst mailing list