How to display non ascii words or character in php?

Question

The logical error is that the php doesn't display the desired output for pronunciation. eg. the desired output is \ə-ˈchēv\ but this one \?-?ch?v\ is displayed in the browser.

while($row=mysql_fetch_array($result))
    {
        $out .= "English word: " .$row['word_en'] . "<br>";
        $out .= "Pronunciation: " .$row['pronunciation'] . "<br>";
        $out .= "Grammar: " .$row['grammar'] . "<br>";
        $out .= "Definition: ".'<div style="width:600px; border:0px solid orange; margin-left: 90px; word-wrap:break-word; margin-top: -19px;">'. $row['definition'] . "</div>";

        //iconv("UTF-8", "ISO-8859-1//TRANSLIT", $out), PHP_EOL; //displays error

        echo $out;
    }

By the way, plain mysql extenaion is deprecated. Use mysqli or pdo instead. It will offers you some new features such as prepared statements — david8, Aug 13 '15 at 06:08

score 0 · Answer 1 · answered Aug 13 '15 at 05:36

0

You should set

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

to your browser HTML code

answered Aug 13 '15 at 05:36

Harshit

5,147
9
46
93

I already added that but still it doesn't work. Why oh why? I think the problem is with the php. – Jude Howell Sarabia Aug 13 '15 at 05:44

score 0 · Answer 2 · edited Mar 17 '17 at 11:24

0

This is problem with MySQL. Please check, which collation is used

In connection (PHP code connecting to mysql)
In database
In tables
In columns

These can have different collations.

(mysql replaces characters it doesn't know with question marks)

edited Mar 17 '17 at 11:24

marc_s

732,580
175
1,330
1,459

answered Aug 13 '15 at 06:03

david8

444
9
23

I changed the character set to utf8 and collation to utf8_general_ci. The output works good in navicat mysql but not in php. – Jude Howell Sarabia Aug 13 '15 at 06:09
And what collation you use on database connection? @Judo100 – david8 Aug 13 '15 at 06:10
$connection = mysqli_connect("localhost","root","","dictionary"). none – Jude Howell Sarabia Aug 13 '15 at 06:11
. I added the header but still it doesn't work. – Jude Howell Sarabia Aug 13 '15 at 06:12
After connection do query "SET NAMES utf8" – david8 Aug 13 '15 at 06:14
Other note: utf8 in mysql is crippled. It cannot store fourbyte characters. You should use utf8mb4 instead. – david8 Aug 13 '15 at 06:15
And are you sure that collation in columns is also utf8? – david8 Aug 13 '15 at 06:17
only 1 column is utf8. – Jude Howell Sarabia Aug 13 '15 at 06:22
You probably want store data in all columns in utf8, right? – david8 Aug 13 '15 at 06:23
I mean only one is utf8 for the pronunciation column and I just want that to be displayed properly in php. – Jude Howell Sarabia Aug 13 '15 at 06:26
Have you added SET NAMES query? I highly recommend having everything in modern encoding UTF-8 – david8 Aug 13 '15 at 07:41

How to display non ascii words or character in php?

2 Answers2