PHP and Mysql special chars

Question

i haven't found the answer at this question browsing around so i guess asking it's ok...

My php code reads from my Mysql Database a string and prints it, here is the code

$sql2=mysql_query("SELECT * FROM Corsi WHERE Nome='$Ln_1[Ln_1]'");
$Ln_1_a = mysql_fetch_array($sql2);
$Ln_1_descr = $Ln_1_a[5];

But special chars, such as 'è' 'à' 'ò' etc. are printed as '�'. My Mysql Encoding is utf8 and also in my html header i have utf8 encoding, so what is wrong with this?

Thanks in advance

Community · Accepted Answer · 2017-05-23 12:29:29Z

2

First of all, at the start of your MySQL connection after database selection you should put this query:

mysql_query('SET NAMES utf8');

Then be sure, your page has encoding UTF-8 (I guess you are using HTML, so it should looks like:

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

) and also your script file must be saved in UTF8 encoding.

But I have to remind mysql_* functions are deprecated and you should use mysqli_* or PDO instead with prepared statements due to safety of your queries.

edited May 23, 2017 at 12:29

CommunityBot

11 silver badge

answered Sep 9, 2014 at 11:29

Lkopo

4,8538 gold badges37 silver badges60 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Mike S. · Accepted Answer · 2014-09-09 11:20:13Z

1

Try (after mysql_connect) do mysql_query('SET NAMES utf8'). And also check, if font support these characters.

answered Sep 9, 2014 at 11:20

Mike S.

2,11114 silver badges25 bronze badges

Comments

Wezy · Accepted Answer · 2014-09-09 11:29:53Z

0

Use the utf8_decode function

like this

$Ln_1_descr = utf8_decode($Ln_1_a[5]);

answered Sep 9, 2014 at 11:29

Wezy

6671 gold badge5 silver badges14 bronze badges

Comments

Bear 곰 · Accepted Answer · 2014-09-09 11:32:43Z

0

Use htmlspecialchars($yourvariable, ENT_NOQUOTES, "UTF-8")

Also verify your MySQL configure file has:

[client] default-character-set=UTF-8

[mysql] default-character-set=UTF-8

Also, utf8_encode() and utf8_decode() would work for you as well.

answered Sep 9, 2014 at 11:32

Bear 곰

351 silver badge7 bronze badges

Collectives™ on Stack Overflow

PHP and Mysql special chars

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related