[Catalyst] utf8 in mysql

[Angel Kolev]

Thank you very much!
It works, but whitout "mysql_enable_utf8 => 1, " ([error] Caught 
exception in engine "Wide character in syswrite at 
/usr/local/share/perl/5.8.8/Catalyst/Engine.pm line 626.")
Tobias Kremer wrote:
> Quoting Angel Kolev <ankolev at gmail.com>:
>
>   
>> Hi all. I have problem when fetch data from mysql. All data is in utf8
>> and in my phpmyadmin i can see all chars correctly. I dont know how to
>> tell to my model to fetch data in utf8. With standart DBI module i can
>> do it with :
>>
>> $dbh->do("set character set utf8");
>> $dbh->do("set names utf8");
>>     
>
> Try this:
>
> __PACKAGE__->config(
>     schema_class => 'MyApp::FooSchema',
>     connect_info => [
>         'your_dsn',
>         'username',
>         'password',
>         {
>             mysql_enable_utf8   => 1,
>             on_connect_do       => [
>                 "SET NAMES 'utf8'",
>                 "SET CHARACTER SET 'utf8'",
>             ],
>         }
>     ],
> );
>
> HTH,
>
> --Tobias
>
> _______________________________________________
> List: Catalyst at lists.scsys.co.uk
> Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst
> Searchable archive: http://www.mail-archive.com/catalyst@lists.rawmode.org/
> Dev site: http://dev.catalyst.perl.org/
>
>