joepeacock
Programmer
I am attempting to store Chinese text in a table with UTF-8 encoding and utf8_general_ci collation. After being stored, they are retrieved and displayed on a web page. On that page, which is properly set to use the UTF-8 character
set, about 95% of the characters are correct, but a few are replaced with question marks and boxes. the fact that most are correct indicates to me that my settings are correct in all places, but perhaps the UTF-8 Character set is incomplete.
Characters that work fine (Hex):
? (C3A5CB86E280BA)
? (C3A9E282ACC2A0)
? (C3A7C5B8C2A5)
? (C3A7E280B0C592)
Characters that are not working (Hex):
? (C3A53F3F)
? (C3A5E2809C3F)
? (C3A6CB863F)
I am using ColdFusion MX 7 and the MySQL ODBC connector on a Windows machine. This is a shared hosting environment, so I may not be able to upgrade anything.
Any ideas if there is a solution to this, or am I stuck?
set, about 95% of the characters are correct, but a few are replaced with question marks and boxes. the fact that most are correct indicates to me that my settings are correct in all places, but perhaps the UTF-8 Character set is incomplete.
Characters that work fine (Hex):
? (C3A5CB86E280BA)
? (C3A9E282ACC2A0)
? (C3A7C5B8C2A5)
? (C3A7E280B0C592)
Characters that are not working (Hex):
? (C3A53F3F)
? (C3A5E2809C3F)
? (C3A6CB863F)
I am using ColdFusion MX 7 and the MySQL ODBC connector on a Windows machine. This is a shared hosting environment, so I may not be able to upgrade anything.
Any ideas if there is a solution to this, or am I stuck?