W3hobbyist

Web developers working with Indian devanagari language may face some issues while pulling out strings from the MySQL database. If not done correctly, one will get a series of question marks instead of the devanagari.

Solution:

Set the ‘collation’ of the database, table and column to ‘utf8_unicode_ci‘. Now, whenever you want to retrieve the unicode string, simply run the below given query before running the actual query to retrieve the unicode string.

mysql_query("SET NAMES 'utf8'");//run this query first
$resource=mysql_query('SELECT book_title FROM hindi_marathi_books');

Thats it! Now use PHP to parse the strings as you like!

Bookmark It

Hide Sites

This entry was posted on Thursday, May 14th, 2009 at 4:37 pm and is filed under PHP-MySQL. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.