How to display Unicode data with PHP

Question

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;

?>

If this is PHP code, do _not_ use the old `mysql_*` API; switch to the newer (and safer) `mysqli_*` or `PDO`. — Rick James, Jun 27 '19 at 22:41
See "question mark" in https://stackoverflow.com/questions/38363566/trouble-with-utf8-characters-what-i-see-is-not-what-i-stored — Rick James, Jun 27 '19 at 22:43

score 37 · Accepted Answer · answered Mar 15 '10 at 11:49

37

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 Mar 15 '10 at 11:49

antyrat

27,479
9
75
76

1

@JeffDavis They are different and you need to use all 3 – antyrat Oct 02 '13 at 21:00
1

@KasunSiyambalapitiya try this: `mysqli_set_charset($link, 'utf8');` – antyrat Jun 05 '16 at 12:31
If you are going to update a field using that getting from a select statement, execute the above configurations after select query execution. – namal Feb 21 '19 at 10:06

MohsenB · Answer 2 · 2016-11-16T18:06:15.533

10

For new version of PHP which used mysqli, use this code after connect to mysql:

mysqli_set_charset($link, 'utf8');

edited Nov 16 '16 at 18:06

answered Nov 10 '15 at 20:37

MohsenB

1,669
18
29

You are my hero bro! – Mustafa Erdogan Aug 11 '18 at 13:28

score 7 · Answer 3 · answered Mar 15 '10 at 11:46

Try to make sure the browser recognizes the page as Unicode.

Generally, this can be done by having your server send the right Content-type HTTP header, that includes the charset you're using.

For instance, something like this should work :

header('Content-type: text/html; charset=UTF-8');
echo "வெள்ளிக்கிழமை ஐ";

If this works, and your dynamically generated page still doesn't :

make sure your data in your MySQL database is in UTF-8 too
- this can be set for each table, or even columns, in MySQL
and make sure you are connecting to it using UTF-8.

Basically, all your application should use the same encoding :

PHP files,
Database
HTTP server

I had to combine your answer and antyrat's answer to get it work — mili, Aug 19 '15 at 16:30

score 3 · Answer 4 · answered Mar 15 '10 at 11:49

3

execute query

SET NAMES 'utf8'

right after connecting to database

answered Mar 15 '10 at 11:49

Silver Light

44,202
36
123
164

score 0 · Answer 5 · answered Oct 10 '13 at 10:28

<?php header('Content-type: text/html; charset=UTF-8');echo "<font face='Bamini' size='5'>" . "m.Nkhfd; Fkhh;" ."<br />";
echo "<font face='Bamini' size='10'>" . "m.Nkhfd; Fkhh;" ."<br />";
?>

or

<?php
header('Content-type: text/html; charset=UTF-8');
echo "à®µà¯†à®³à¯à®³à®¿à®•à¯à®•à®¿à®´à®®à¯ˆ à®";
?>

score 0 · Answer 6 · answered Mar 15 '10 at 11:45

0

First you need to convert your mysql data format to utf-8, see this great article by oreilly:

.

Turning MySQL data to UTF-8

.

After that make sure that your page's encoding type is utf-8:

<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />

answered Mar 15 '10 at 11:45

Sarfraz

377,238
77
533
578

@Srinivas Tamada: The final answer you chose did the same thing what has been told in the oreily article i posted the link above. Anyways, it is good that you found the solution. Thanks.. – Sarfraz Mar 15 '10 at 12:02
Link is dead, which is why answers should not be links. – NateS Mar 23 '20 at 11:42

score -1 · Answer 7 · edited Aug 14 '19 at 13:24

-1

While inserting the data into a MySQL database using the relevant collation (ex. utf8_general_ci for Unicode characters, i.e Hindi). Also in use the PHP predefined function utf8_decode to display the characters in HTML.

edited Aug 14 '19 at 13:24

ndrwnaguib

5,623
3
28
51

answered Aug 14 '19 at 10:40

sachu forever

1

How to display Unicode data with PHP

OutPut displaying like this:

But I want to display

Solution

7 Answers7

Linked