UTF 8 mysql problem with quote character
Posted: Mon Mar 05, 2012 10:07 am
My database collation is utf8_general_ci.
My table collation is utf8_general_ci.
My table's `scope` field collation is utf8_general_ci.
My html page has <meta charset="utf-8">
But when I echo $query[10]['scope'];
instead of getting (’) I get (�)
In phpMyAdmin when looking at the same data I see the proper quote character.
The phpmyadmin page is also specifying utf-8 <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
What am I doing wrong?
This has been a pain in my side since I first started using php/mysql 7 years ago and I seem to be no closer to having a clue.
My table collation is utf8_general_ci.
My table's `scope` field collation is utf8_general_ci.
My html page has <meta charset="utf-8">
But when I echo $query[10]['scope'];
instead of getting (’) I get (�)
In phpMyAdmin when looking at the same data I see the proper quote character.
The phpmyadmin page is also specifying utf-8 <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
What am I doing wrong?
This has been a pain in my side since I first started using php/mysql 7 years ago and I seem to be no closer to having a clue.