Re: [Dbix-class] Unicode conversion problems

the character set when adding new tables (or columns) to that schema. Regards Matias E. Fernandez ___ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class IRC: irc.perl.org#dbix-class SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class

Re: [Dbix-class] Unicode conversion problems

(SELECT * FROM foo); $sth-execute(); while (my $ref = $sth-fetchrow_hashref()) { print $ref-{'author'}\n; } $sth-finish(); What do you get there? Regards Matias E. Fernandez ___ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class

Re: [Dbix-class] Unicode conversion problems

-8. There you have double encoded UTF-8! The solution is simply to use mysql_enable_utf8 as part of the call to 'connect()'. If you're using DBIx::Class I recommend also disabling the mysql_auto_reconnect option, this will save you a lot of headache. Regards Matias E. Fernandez

Re: [Dbix-class] Unicode conversion problems

] by Joel Spolsky. That doesn't seem good. Quite the contrary, it most definitely does! :-) Regards Matias E. Fernandez [1] http://perldoc.perl.org/perluniintro.html#Perl's-Unicode-Model [2] http://perldoc.perl.org/5.10.0/perlunifaq.html#What-is-a-%22wide-character%22%3f [3] http

Re: [Dbix-class] Unicode conversion problems

warnings): binmode(STDOUT, :encoding(UTF-8)); Thanks for looking at this so closely. You are welcome! Regards Matias E. Fernandez [1] http://dev.mysql.com/doc/refman/5.1/en/charset-convert.html ___ List: http://lists.scsys.co.uk/cgi-bin/mailman

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

implications if a library you use doesn't respect Perl's Unicode model! I was just trying to be helpful. Like I said, I'm no unicode expert. Thank you very much. I'm trying to be helpful too by pointing at an existing and real problem. Regards Matias E. Fernandez [1] http://perldoc.perl.org

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

format. My question remains: is deflate/inflate a safe place to do encoding, or will it suffer the same flaws as DBIx::Class::UTF8Columns? Regards Matias E. Fernandez [1] http://perldoc.perl.org/5.12.0/perlunifaq.html#I-lost-track%3b-what-encoding-is-the-internal-format-really%3f [2] http

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

. Regards Matias E. Fernandez ___ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class IRC: irc.perl.org#dbix-class SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/ Searchable Archive: http://www.grokbase.com/group/dbix-class