Apache or mysql issue?

[blackhorse]

I have installed zend server on windows vista. And I also have a LAMP too.

Same php page and same php codes, But when I test it on Zend Server (Apache and Mysql on windows vista), this "ü" char from mysql database turned to garbage chars. But if I test it on the LAMP, then the "ü" is converted. I used the same msyql_dump to recreate database both on winodws vista and linux.

I use htmlspecialchars on it, still "ü" shows as garbage chars on Zend Server.

I also run into some problems like I passed contents with "ü" kind special characters from my LAMP to 3rd party web server, they don't save it, they just mail the content out for me. It works before but suddenly, something changed in the 3rd party server, these "ü" special characters turned to garbage chars.

What should I know about these "ü" special characters if the web pages running on apache/mysql on windows platform or apache/mysql on linux platform? I would assume they would be the same. But it was not.

Thanks!

[NogDog]

My guess is that one server is serving up pages as UTF-8 by default, while the other is serving up something like ISO-8859-1 for the default character set. To see if this is the issue, you can check the response headers in your browser, or you can force on or the other via header():

<?php
header('Content-Type: text/html; charset=utf-8');

Then see if both versions output it the same.

[blackhorse]

I have already forced the same header in the web pages on both servers. Could that be due to the mysql server default set up is different? But I use the same mysql dump file to recreate the tables and data on both mysql servers. The tables on both server are in same character set.