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

[Rami Addady]

Hello Ephraim,


Actually I'm migrating application form Mysql 3.23 to 4.1.

I prefer not do add load to the application  by encode/decode each call 
to the database, it very busy already.

Do you know what encoding in Mysql in equivalent to the internal perl 
encoding.


Regards,
Rami Addady


Ephraim Dan wrote:

>You might want to read
>
>perldoc Encode
>
>You'll need to encode/decode your strings between their actual encoding
>(which appears to be "ISO 8859-8 Hebrew" since that is what MySQL's
>"hebrew" character set maps to), and perl's internal form.
>
>HTH
>
>-Ephraim
>
>  
>
>>-----Original Message-----
>>From: perl-bounces at perl.org.il [mailto:perl-bounces at perl.org.il] On
>>    
>>
>Behalf
>  
>
>>Of Rami Addady
>>Sent: Tuesday, September 27, 2005 16:58
>>To: perl at perl.org.il
>>Subject: [Israel.pm] Can't use Hebrew with perl on mysql 4.1
>>
>>Hello,
>>
>>
>>I'm using mysql 4.1.10 and perl v5.8.5 on the latest version of CentOS
>>4.1 (RedHat AS 4.1 clone)
>>
>>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.
>>
>>Other application like php (using phpmyadmin) or mysql shell command
>>work fine with Hebrew on the same table.
>>
>>The table was create using hebrew character set:
>>CREATE DATABASE `table-name` DEFAULT CHARACTER SET hebrew COLLATE
>>hebrew_general_ci;
>>
>>Any Idea ?
>>
>>Regards,
>>
>>Rami Addady
>>
>>_______________________________________________
>>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
>  
>