[Israel.pm] Can't use Hebrew with perl on mysql 4.1, [Solved]

Rami Addady rami at active.co.il
Sun Oct 2 10:12:03 PDT 2005


Hello,


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


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.
>
>
> Rami
>
>
> 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 
>>> fetch
>>> ????? 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
>> unfortunatelly
>> I don't recall the exact version number.
>>
>> Gabor
>>
>> _______________________________________________
>> Perl mailing list
>> Perl at perl.org.il
>> http://perl.org.il/mailman/listinfo/perl
>>  
>>
> _______________________________________________
> Perl mailing list
> Perl at perl.org.il
> http://perl.org.il/mailman/listinfo/perl




More information about the Perl mailing list