Hi everybody,
I've setup a table with UTF8 character set in MySQL database, within the record, it contains
2 different language wordings like simplify chinese and traditional chinese (both in UTF8 format).
The wording display
correctly within the phpmyadmin and my program frontend. But when i perform some keyword searching
using sql query, it can't retrieve any rows. I've double checked the table and sure that the
keyword exists in the table. Then i try to copy some wordings as the keyword within the phpmyadmin
and use the sql statement to retrieve again within phpmyadmin. Some keywords can return row but some can't.
Both keywords are copied from the table rows but some of them didn't return any rows.
Anybody can help me? What else i need to check first?
Thanks for your advice.
K23
I've setup a table with UTF8 character set in MySQL database, within the record, it contains
2 different language wordings like simplify chinese and traditional chinese (both in UTF8 format).
The wording display
correctly within the phpmyadmin and my program frontend. But when i perform some keyword searching
using sql query, it can't retrieve any rows. I've double checked the table and sure that the
keyword exists in the table. Then i try to copy some wordings as the keyword within the phpmyadmin
and use the sql statement to retrieve again within phpmyadmin. Some keywords can return row but some can't.
Both keywords are copied from the table rows but some of them didn't return any rows.
Anybody can help me? What else i need to check first?
Thanks for your advice.
K23