Fail to migrate non Unicode data to mysql 4.1.10

Hello,

I'm migrating application and database form Mysql 3.23 to
mysql 4.1.10 and perl v5.8.5 on the latest version of CentOS 4.1 (RedHat 
AS 4.1 clone)

The tables was create using Hebrew character set:
CREATE DATABASE `table-name` DEFAULT CHARACTER SET hebrew COLLATE
hebrew_general_ci;

And all the data was inserted from the old database dump.

Only from Perl I can't work properly with this Hebrew data. Perl application
can't display the Hebrew text or insert proper Hebrew.  DBI module
fetch ????? values  and insert  nulls instead of Hebrew character to/from
the DB.

Other application like php (using phpmyadmin) or mysql shell command
work fine with Hebrew on the same table.

Installing the latest stable DBD module (DBD-mysql-3.0002) didn't help much.

Please advice.

Regards,
Rami Addady


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