-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Hi,
Oliver König schrieb:
Sarge
====
mysql 4.0.24
Etch
====
mysql 5.0.32
In mysql everything looks fine, too:
I doubt ..
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?
As you show in your query, the results are in latin1. I would guess
it is the upgrade of mysql which is your problem. So try to solve the
problem in mysql not Perl.
Cheers
C.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iD8DBQFGQvO3rKb2iXSP9HYRAtdhAKCnJHGJRe/+SbvVUyDJVBNegXg6rQCfTfn2
opttpYX19epCeWfJMsGf0ZY=
=LB2m
-----END PGP SIGNATURE-----