HexaHow's questions

My characters are in Chinese Simplified that stored in MySQL database by all tables and character set to UTF-8.

I am reading them to my PHP page that runs under resin server on Windows XP Professional.

My Resin server version is 4.0.15; PHP version is 5.3.2; and MySQL is 5.5.

Any idea how to retrieve the Chinese character data to my PHP page and displaying them in correct Chinese words? I get the Question Mark ("?") on those Chinese characters.

If I am typing Chinese character on PHP page, it can display correct Chinese words on web page. So, I assume is the connection between MySQL and PHP have problem.

But previously when I was running under Apache, there is no character problem. May I know why?

It seems like SQL Server 2008 does not support code page 65001 when using Bulk Insert. If I use other code pages, my data is corrupted when imported. Is there a way to insert my UTF8 data properly in SQL Server 2008 using scripts?