How to display Unicode data with PHP

Asked 2010-03-15T11:42:56.387

table 'abc' data :

tid    title

  1      வெள்ளிக்கிழமை ஐ.

  2      கோலாகல தொடக்க 


$sql=mysql_query("select title from abd where tid='1'");

$row=mysql_fetch_array($sql);

$title = $row['title'];

echo $title;

OutPut displaying like this:

????????????????

But I want to display

வெள்ளிக்கிழமை ஐ.

Solution

<?php
    mysql_query ("set character_set_results='utf8'");   

    $sql=mysql_query("select title from abd where tid='1'");

    $row=mysql_fetch_array($sql);

    $title = $row['title'];

    echo $title;

?>

php mysql unicode

Edit Report

2 Answers

Try to set charachter encoding after mysql_connect function like this:

 mysql_query ("set character_set_client='utf8'"); 
 mysql_query ("set character_set_results='utf8'"); 

 mysql_query ("set collation_connection='utf8_general_ci'");

answered 2010-03-15T11:49:15.533

execute query

SET NAMES 'utf8'

right after connecting to database

answered 2010-03-15T11:49:36.827

How to display Unicode data with PHP

OutPut displaying like this:

But I want to display

Solution

2 Answers

Your Answer