0

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?

2
Contributors
1
Reply
2
Views
7 Years
Discussion Span
Last Post by colweb
1

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.

Edited by colweb: n/a

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.