Web Analytics Made Easy -
StatCounter Text search in MySQL database - CodingForum


No announcement yet.

Text search in MySQL database

  • Filter
  • Time
  • Show
Clear All
new posts

  • Text search in MySQL database

    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!

  • #2
    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.