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

[Matt S Trout]

On Fri, Mar 03, 2006 at 10:14:54AM +0000, Paul Makepeace wrote:
> Je 2006-03-03 10:10:49 +0000, Michele Beltrame skribis:
> > 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.
> 
> As an anecdotal datapoint, I didn't find this to be of use; it seemed to
> garble the output. At the same time, I didn't look too hard at it.

I know on_connect_do works. I didn't suggest the 'set names utf8' bit this
time round and I'm not familiar with the problem myself.

> Matt - did you suggest this off the back of my experimentation on IRC
> or have you actually had it work?

Somebody else suggested it; I'm more hopeful about the UTF8Columns component
that Daisuke (typester) is working on.

-- 
     Matt S Trout       Offering custom development, consultancy and support
  Technical Director    contracts for Catalyst, DBIx::Class and BAST. Contact
Shadowcat Systems Ltd.  mst (at) shadowcatsystems.co.uk for more information

 + Help us build a better perl ORM: http://dbix-class.shadowcatsystems.co.uk/ +