When we want to display and store the data other than ENGLISH using PHP.
Below is the code used to save and retrieve the data in PHP.
mysql_set_charset('utf8',$db_connect);
where $db_connect is the "MySQL Host" connection handler. You can see the example below for the connection handler.
<?php
$db_connect = mysql_connect(HOST_NAME,USERNAME,PASSWORD);
mysql_set_charset('utf8',$db_connect);
?>
By using the above, we can store and retrieve the data in different languages like Telugu, French, Hindi, German and many.
Note: And also a major note we need to be keep in mind, when we try to retrieve the same UTF-8 converted data using AJAX. We should not use "mysql_set_charset" as AJAX by default sets the content as "UTF-8"
