Hello list,
we have used Debian Sarge for almost 2 years on our server. It took us a lot
of hard work to set up the system, the database, PERL, Apache etc.to use
UTF-8 as the default character set. But in the end it worked fine on Sarge.
When Etch came out we read that everything in Etch now defaults to UTF-8
character encoding so we decided to upgrade from from Sarge to Etch.
Unfortunately after the upgrade the character encoding on our website was
messed up and it looks like the reason for that is PERL. The mess is causing
tremendous damage to our website.
the operating system and Apache seem to use UTF-8. So, that'S good
In mysql everything looks fine, too:
mysql> SHOW VARIABLES LIKE "character_set_%";
+--------------------------+----------------------------+
| Variable_name | Value |
+--------------------------+----------------------------+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | utf8 |
| character_set_filesystem | binary |
| character_set_results | utf8 |
| character_set_server | utf8 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
However a PERL script with dbh->do(SHOW VARIABLES LIKE "character_set_%");
returns:
character_set_client latin1
character_set_connection latin1
character_set_database utf8
character_set_filesystem binary
character_set_results latin1
character_set_server utf8
character_set_system utf8
character_sets_dir /usr/share/mysql/charsets/
How can we tell PERL to use UTF-8 as default encoding?