Re: DBD::mysql and utf-8 problem

On Fri, 27 Jun 2008, Helmut Zeilinger wrote:

=>Hi Dwalu,
=>
=>that is clear... I checked that (in the same script) by
=>
=>..
=>my $vars = $dbh->selectall_arrayref (qq (show variables like 'char%'));
=>
=>foreach my $var (@$vars) {
=>    print qq ($var->[0] = $var->[1] \n);
=>}
=>..
=>
=>which prints out
=>
=>"character_set_client = utf8
=>character_set_connection = utf8
=>character_set_database = utf8
=>character_set_filesystem = binary
=>character_set_results = utf8
=>character_set_server = utf8
=>character_set_system = utf8
=>character_sets_dir = /usr/share/mysql/charsets/"
=>
=>
=>So i think, this is not the problem.
=>
=>Just an idea:
=>
=>In the source code of the DBD::mysql driver i found the
=>function "sv_utf8_decode"  processing the utf8 results.
=>
=>Wouldn't "sv_utf8_downgrade" make sence?
=>
Aha!  I was unaware if you'd already configured your app.  Hmmmmmm, I'm 
not sure about sv_utf8_downgrade, however I've created several UTF-8 apps 
using perl and mysql without problems so curious why yours -doesn't just
work- :s

In any case, I don't have the cycles at the moment to test and it would 
seem you may have those changes already or coming soon enough.  I look 
forward to reading the results--cheers!


-- 
				- Dwalu
.peace
--
I am an important person in this world -
Now is the most important time in my life -
My mistakes are my best teachers -
So I will be fearless.
				- Student Creed

-- 
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe:    http://lists.mysql.com/[email protected]