Re: DBD::mysql and utf-8 problem

Hi Rob,


i testet this and got no change.

Of course i testet a "real" query from a real table also; with the same 
results.

I have the "feeling" with the Server + Database everything is fine
(mysql command line output on a utf8 console is ok,
mysqldump works ok,
didn't yet check a jbdc driver..),
but it is really a driver issue..

Thank You

Helmut


Rob Mueller schrieb:
>> my $text = $dbh->selectrow_array (qq (select ?), undef, $aeu);
>>
>> Why does Perl not calculate the correct number of characters?
>> Does one (still) have to decode every string value received from the 
>> DBD::mysql driver?
>
> I haven't tested this, but maybe there's some confusion over the 
> charset type of the data. The documentation talks about the actual 
> data having to be utf8 data (eg a latin1 column will come back as 
> octet data, not a perl utf8 string). Maybe try this:
>
> my ($text) = $dbh->selectrow_array (qq (select convert(? using utf8)), 
> undef, $aeu);
>
> Rob
>


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