[Israel.pm] Can't use Hebrew with perl on mysql 4.1, [Solved]
rami at active.co.il
Sun Oct 2 10:12:03 PDT 2005
Adding those commands after the connect solve the problem:
$dbh->do("SET character_set_client = hebrew");
$dbh->do("SET character_set_connection = hebrew");
$dbh->do("SET character_set_results = hebrew");
Rami Addady wrote:
> Just updrade form DBD 2.9004 to 3.0002. but still have the same problem.
> When using mysql with hebrew charset: php and shaell work fine pert not.
> When using mysql utf8 charset: perl allso work fine.
> The point is that all my data in hebrew charset and I did't find easy
> way to convert it to utf8.
> Gábor Szabó wrote:
>> On 9/27/05, Rami Addady <rami at active.co.il> wrote:
>>> Only from perl I can't work properly on Hebrew data. Perl application
>>> can't display the Hebrew text or insert proper Hebrew. DBI module
>>> ????? values and insert nulls instade of hebrew charcater to/from
>>> the DB.
>> I encountered similar problem with recent versions of DBD::Mysql,
>> I think 2.9004 or around that was working correctly.
>> I did not have the time and interest then to analyze it further and
>> I don't recall the exact version number.
>> Perl mailing list
>> Perl at perl.org.il
> Perl mailing list
> Perl at perl.org.il
More information about the Perl