Not support utf-8: Where is the problem?

[wow]

Hi there,

My web server on Windows 7 displays all utf-8 chars well but not on Linux even both MySQL database is created with "CHARACTER SET utf8 COLLATE utf8_unicode_ci", and all php pages are created with utf-8. Where is the problem pn Linux: Apache configuration or php5 configuration? Both use Apache as web server.

Thanks,

[wow]

I think this would be easy for those who know well of Apache and php, am I right?

Thanks,

[NogDog]

Here's most of what I know on the subject: http://www.charles-reace.com/blog/20...php-and-mysql/

[wow]

Thanks, NogDog, a nice link. I'll try it out and let you know, have a nice day,

[wow]

For some reason, it doesn't work out. In the code, PDO is used as below:

new PDO("mysql:host={$dbhost};dbname={$db};charset=utf8",$userid, $pw,
array(PDO::ATTR_EMULATE_PREPARES => false, PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION));

Also, I check mysql, all setting is utf8 as below. Use Aqua Data Studio to display, it doesn't show correct, even correct by connecting to mysql on Windows. More strange is another page using mysqli displaying the content correct. Do this mean the problem is PDO?
Before the string is sent to mysql, it's handled by addslashes function.

Thanks,
mysql> show variables like 'char%';
+--------------------------+----------------------------+
| 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/ |
+--------------------------+----------------------------+
8 rows in set (0.00 sec)

mysql> show variables like 'collation%';
+----------------------+-----------------+
| Variable_name | Value |
+----------------------+-----------------+
| collation_connection | utf8_general_ci |
| collation_database | utf8_unicode_ci |
| collation_server | utf8_unicode_ci |
+----------------------+-----------------+

[NogDog]

Have you tried doing the SET NAMES 'utf8' COLLATE 'utf8_unicode_ci' query before doing any other queries (read or write)?

[wow]

It's proved the problem is PHP MySQL PDO module: in the same php page, both mysqli and PDO are used in almost the same way, the same query by mysqli displays result properly, but not the one with PDO:
mysqli: displays - This is a 鮓lunch menu
PDO: displays -This is a 鮓lunch menu

In Windows platform (both PHP and MySQL installed on Windows), both are the same.

Even PDO constructs the connection with utf8 as below:
$pdo = new PDO("mysql:host={$dbhost};dbname={$db};charset=utf8",$userid, $pw,
array(PDO::ATTR_EMULATE_PREPARES => false, PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION));

Please help where is problem the above pdo statement. I'm told PDO has more advantage.

Thanks,

[wow]

Thanks NogDog, it's done:

$anum = $pdo->exec("SET NAMES 'utf8' COLLATE 'utf8_unicode_ci'");

[wow]

Does this mean I have to give up PDO and turn to use mysqli? Is this a bug of mysql PDO?

Thanks,

[wow]

Have you tried doing the SET NAMES 'utf8' COLLATE 'utf8_unicode_ci' query before doing any other queries (read or write)?

Yes, I did right away after the connection is got with:
$anum = $pdo->exec("SET NAMES 'utf8' COLLATE 'utf8_unicode_ci'");

Even it's not needed for my mysql configuration, it's a unnecesary step, I think, but, just in case.

Thanks,