Re: [Dbix-class] Wrong UTF-8 handling in DBIx::Class/DBD::mysql despite mysql_enable_utf8

2010-05-21 Thread Alexander Hartmaier
Why not just switch to a real db like Postgres or Oracle, I'm sure that will fix your problem as well. -- Best regards, Alex Am Donnerstag, den 13.05.2010, 18:11 +0200 schrieb Matias E. Fernandez: Hello again On 2010-05-13, at 24:19, Marc Mims wrote: I disagree with that. Consider this:

Re: [Dbix-class] Wrong UTF-8 handling in DBIx::Class/DBD::mysql despite mysql_enable_utf8

2010-05-13 Thread Matias E. Fernandez
Hello again On 2010-05-13, at 24:19, Marc Mims wrote: I disagree with that. Consider this: my $string = \x{e4}\x{f6}\x{fc}; utf8::upgrade($string); my $other_string = \x{e4}\x{f6}\x{fc}; ok($string eq $other_string, upgraded and not upgraded character strings are equal); Both

Re: [Dbix-class] Wrong UTF-8 handling in DBIx::Class/DBD::mysql despite mysql_enable_utf8

2010-05-12 Thread Marc Mims
* Matias E. Fernandez pi...@gmx.ch [100512 04:36]: This is about The Unicode Bug [2] and will cause the following test to fail: my $title = \x{e4}\x{f6}\x{fc}; # äöü This isn't a UTF-8 string. utf8::is_utf8($title); # false utf8::upgrade($title); # now it is $album-title($title);

Re: [Dbix-class] Wrong UTF-8 handling in DBIx::Class/DBD::mysql despite mysql_enable_utf8

2010-05-12 Thread Matias E. Fernandez
Hello Marc On 2010-05-12, at 15:40, Marc Mims wrote: my $title = \x{e4}\x{f6}\x{fc}; # äöü This isn't a UTF-8 string. utf8::is_utf8($title); # false utf8::upgrade($title); # now it is It is a string consisting of the three characters \x{e4}, \x{f6} and \x{fc}. That's about all I

Re: [Dbix-class] Wrong UTF-8 handling in DBIx::Class/DBD::mysql despite mysql_enable_utf8

2010-05-12 Thread Marc Mims
* Matias E. Fernandez pi...@gmx.ch [100512 07:43]: On 2010-05-12, at 15:40, Marc Mims wrote: my $title = \x{e4}\x{f6}\x{fc}; # äöü This isn't a UTF-8 string. utf8::is_utf8($title); # false utf8::upgrade($title); # now it is It is a string consisting of the three

Re: [Dbix-class] Wrong UTF-8 handling in DBIx::Class/DBD::mysql despite mysql_enable_utf8

2010-05-12 Thread Matias E. Fernandez
Hi again On 2010-05-12, at 17:16, Marc Mims wrote: It is a string consisting of the three characters \x{e4}, \x{f6} and \x{fc}. That's about all I have to know as a Perl user, reread [1] if in doubt. The important thing to know is that you cannot rely on Perl internally holding strings in

Re: [Dbix-class] Wrong UTF-8 handling in DBIx::Class/DBD::mysql despite mysql_enable_utf8

2010-05-12 Thread Nick Wellnhofer
On 12/05/10 23:25, Matias E. Fernandez wrote: Not quite. I get back decoded UTF-8 data, yes! That's why you'll find sv_utf8_decode in the DBD::mysql source, but nowhere do you find an encode! This looks like a bug in DBD::mysql. Nick ___ List:

Re: [Dbix-class] Wrong UTF-8 handling in DBIx::Class/DBD::mysql despite mysql_enable_utf8

2010-05-12 Thread Marc Mims
* Matias E. Fernandez pi...@gmx.ch [100512 14:29]: On 2010-05-12, at 17:16, Marc Mims wrote: It is a string consisting of the three characters \x{e4}, \x{f6} and \x{fc}. That's about all I have to know as a Perl user, reread [1] if in doubt. The important thing to know is that you