Re: utf8 and mysql

On Wed, Jul 31, 2013 at 7:39 PM, Meir Guttman <[email protected]> wrote:
> Dear Gabor,
> You must include «mysql_enable_utf8 => 1» hash record in the connection attributes used when you create the DBI handle
> my %conn_attrs = (RaiseError    => $RaiseError,
>                   PrintError    => $PrintError,
>                   AutoCommit    => $AutoCommit,
>                   mysql_enable_utf8 => 1);
> my $dbh = DBI->connect
>          ($dsn, $user_name, $password, \%conn_attrs);
>
> Meir
>

That worked. Great. Thank you!

This was entirely unclear to me from the docs that it
needs to be a separate key as I looked a couple of lines
above the documentation of mysql_enable_utf8
where it showed another key, mysql_use_result, being
in the actual connection string.

Gabor