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

Matt S Trout dbix-class at trout.me.uk
Fri Mar 3 18:34:29 CET 2006

On Fri, Mar 03, 2006 at 05:50:50PM +0100, Michele Beltrame wrote:
> Hi!
> > DBIx::Class is an ORM. The config change I suggest should make it run that
> > SQL statement - but I've seen previous reports that 'set names utf8' isn't
> > sufficient, hence also mentioning the UTF8Columns component (which is now
> > in DBIx-Class-current).
> I tried it and it did no good. Also this full-featured version did no good:
> __PACKAGE__->storage->on_connect_do([
> 	'set names utf8',
> 	'set_character_set_client=utf8',
> 	'set_character_set_results=utf8',
> 	'set_character_set_connection=utf8'
> ]);

Did DBI->trace show that being run?

     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/ +

More information about the Catalyst mailing list