Member Avatar for vibhaJ

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
  • 66 Views
  • 8 Hours Discussion Span
  • Latest Post Latest Post by colweb
Member Avatar for colweb

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 because: n/a
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.