Sunday, October 26, 2008

Inserting Unicode Strings to MySQL database in PHP

  • Create MySQL database in coalition utf8_unicode_ci.

  • Add these lines before executing mysql query.

mysql_query("SET character_set_client=utf8");

mysql_query("SET character_set_connection=utf8");

mysql_query("SET character_set_database=utf8");

mysql_query("SET character_set_results=utf8");

mysql_query("SET character_set_server=utf8");

  • Then executer the query which insert UNICODE string to database.

0 comments: