Moving UTF8 websites from Gentoo to Dapper

[Denny Schierz]

hi,

i have real problems to getting my sites working under apache2 with
correct charset.

My Gentoo box has everything in utf-8, means, wordpress, mysql, typo3
etc. Now i want to move the sites from gentoo to dapper.

For example:

http://www.denny-schierz.de/wordpress -> this is the gentoo box
http://www.denny-schierz.de:8888/wordpress -> this is the dapper box

you will see on the second url, that the chars like öäü are not correct.
 I copied the mysql database and the htdocs DIR from the old, to the new
box (1:1).

if you switch the locales from the browser from utf-8 to iso8859-1 on
the dapper box wordpress, the chars will be ok. So, that's the problem
and i don't know what happens.

To test, if the database is the problem, i made it crossover, means, the
 Wordpress from the Gentoo box, getting the DB from dapper, and the
dapper Wordpress gets his database from the gentoo box.

It simply changed nothing. So i assume, that the database is ok:

Dapper Box:

mysql> show variables like '%char%';
+--------------------------+----------------------------+
| Variable_name            | Value                      |
+--------------------------+----------------------------+
| character_set_client     | utf8                       |
| character_set_connection | utf8                       |
| character_set_database   | utf8                       |
| character_set_results    | utf8                       |
| character_set_server     | utf8                       |
| character_set_system     | utf8                       |
| character_sets_dir       | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
7 rows in set (0.00 sec)


Gentoo Box:

mysql> show variables like '%char%';
+--------------------------+----------------------------+
| Variable_name            | Value                      |
+--------------------------+----------------------------+
| character_set_client     | utf8                       |
| character_set_connection | utf8                       |
| character_set_database   | utf8                       |
| character_set_results    | utf8                       |
| character_set_server     | utf8                       |
| character_set_system     | utf8                       |
| character_sets_dir       | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
7 rows in set (0.00 sec)


and the PHP env. are also the same too:

http://www.denny-schierz.de/test.php Gentoo
http://www.denny-schierz.de:8888/test.php Dapper


On the dapper apache i have tested:


#AddDefaultCharset utf-8
#AddDefaultCharset ISO-8859-1
AddDefaultCharset off

nothing changed.

i have no idea, whats getting wrong. :-(

any suggestions?

cu denny



-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 254 bytes
Desc: OpenPGP digital signature
URL: <https://lists.ubuntu.com/archives/ubuntu-users/attachments/20060806/2087c820/attachment.sig>