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

[Bernhard Graf]

Michele Beltrame wrote:

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

Look at 
http://lists.rawmode.org/pipermail/dbix-class/2006-March/000847.html
and the rest of the thread.

HTH
-- 
Bernhard Graf