Its very simple and easy stuff, if you follow things as mentioned bellow. You may find same kind of code shared by other developer. This blog explains PHP – MySQL and Unicode solution to marathi, hindi, gujarathi,Chinese, rashiyan or any other regional languages.
Step 1: Most important is when you make database connection you have to mention “utf-8”.
$dbLink = mysql_connect(HOSTNAME, USERNAME, PASSWORD); mysql_query("SET character_set_results=utf8", $dbLink); mb_language('uni'); mb_internal_encoding('UTF-8'); mysql_select_db(DATABASE, $dbLink); mysql_query("set names 'utf8'",$dbLink);
Step 2: html page header
Make sure that the html header “CHARSET IS SET TO UTF-8”.
Step 3: Data Manipulation statement i.e. insert and update statement.
Make sure that the character set is is uft-8.
mysql_query("SET character_set_client=utf8", $dbLink); mysql_query("SET character_set_connection=utf8", $dbLink); $insert_query = "INSERT INTO TABLE (field_one, field_two) VALUES('value_one', 'value_two')"; mysql_query($insert_query, $dbLink);
You are done with utf.