Text search in MySQL database

[zawedx]

Hi all,

I am not sure is it the right place to post my question, anyway please help me, thanks!

I am wiriting a PHP program that allows users to search item in the MySQL database. The items may have Chinese in their name or desciption. A form is created to allow users to input the search string and then it is transfer to another script to search the MySQL database by GET. I find that some strings can be found but some are not. Is it related to the property of Chinese characters? How can I fix it? Hope I expressed my question clearly.

Thanks a lot!

[guelphdad]

I'd say the problem is the Chinese character set. See the manual regarding character sets, I think there is a specific note/notes on using Chinese character set.