Not support utf-8: Where is the problem?

This site is best viewed in a modern browser with JavaScript enabled.

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/2008/10/03/utf8-in-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.

NogDog

Have you tried doing the [FONT=Courier New]SET NAMES 'utf8' COLLATE 'utf8_unicode_ci'[/FONT] 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

NogDog;1255283 wrote:
Have you tried doing the [FONT=Courier New]SET NAMES 'utf8' COLLATE 'utf8_unicode_ci'[/FONT] 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,