Hello list, we have used Debian (3.1) Sarge for almost 2 years on our serverand everything was encoded in UTF-8.
When Debain Etch (4.0) 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. Sarge ==== Kernel 2.4.27 Apache 2.0.54 mysql 4.0.24 Perl 5.8.4 Etch ==== Kernel 2.6.18 Apache 2.2.3 mysql 5.0.32 Perl 5.8.8 Unfortunately after the upgrade the character encoding on our website was messed up and it looks like the reason for that is PERL. 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? Thanks -- Best regards, Oliver König
