Hi,
I need to use C::M::DBI for a fulltext index with MySQL, and the tables
contain UTF-8 data.
I found that I can use mysql_enable_utf8 but I couldn't find how to use this
option.
I've tried to use it in the model in 2 places as:
__PACKAGE__->config(
dsn => 'dbi:mysql:database=intranet',
user => 'root',
password => undef,
options => {
mysql_enable_utf8 => 1,
},
mysql_enable_utf8 => 1,
);
And I also tried to use it in the controller as
$dbh->{mysql_enable_utf8} = 1;
But with no success. The data still appears not encoded to UTF-8.
What am I doing wrong? Or do I need to make some other configurations?
---Octavian
_______________________________________________
List: Catalyst@lists.scsys.co.uk
Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst
Searchable archive: http://www.mail-archive.com/catalyst@lists.scsys.co.uk/
Dev site: http://dev.catalyst.perl.org/