Hi all,

i want to know that 'Is mysql support chinese language?'
If yes then any changes require in configuration?

My site is in english.
Let if any user have inserted their information in Chinese and if anyone search using Chinese keyword, then it should match with mysql and if matching found in Chinese then that user will be listed in search result.

Any suggestion?

Make sure the table is using charset utf8. Then before you insert or select from this table use

mysql_query("SET character_set_client=utf8", $con);
mysql_query("SET character_set_connection=utf8", $con);

That way Chinese will go in the table and will come out again.