UTF8 mysql encoded database, but not showing special characters in PHP

Question

I have a database with utf_general_ci encoding in MySQL, when I insert data in Navicat or PhpMyAdmin and do queries there, the special characters are returned fine.

But in a php variable they are showing like this:

how they show

My database and collations:

database

and in my html doc if it is a normal

it shows the characters OK, it only not work when is a php variable

please help me

show us how you get these rows and how used php variable? i guess that you not did `"SET NAMES UTF8"` or `charset=UTF-8` — Jason OOO, Oct 09 '13 at 20:18
you need to have the SAME encoding throughout, including on the html page itself. — Marc B, Oct 09 '13 at 20:18
look into `htmlspecialchars` http://www.php.net/manual/en/function.htmlspecialchars.php and `htmlentities` http://www.php.net/manual/en/function.htmlentities.php — cmorrissey, Oct 09 '13 at 20:21
if i do set names utf8 it works, but ive never done that before and was working.. — Mariana Hernandez, Oct 09 '13 at 20:22
`` where i print it and `$rows = array(); $res = mysql_query('SELECT * FROM usuario u, rol r WHERE u.rol_id=r.rol_id'); while ($row = mysql_fetch_array($res)) { $rows[] = $row; } return $rows;` @JasonOOO — Mariana Hernandez, Oct 09 '13 at 20:24
http://stackoverflow.com/questions/2159434/set-names-utf8-in-mysql — Jason OOO, Oct 09 '13 at 20:32

score 4 · Answer 1 · answered Oct 09 '13 at 20:23

4

Try:

$variable = utf8_encode($valueCommingFromDB);

answered Oct 09 '13 at 20:23

João Paulo de Lima

98
1
8

thanks, that works but i dont want to do it at every single variable i will be printing =( – Mariana Hernandez Oct 09 '13 at 20:26

score 1 · Answer 2 · edited May 23 '17 at 12:13

1

It's important to note that utf8 in mysql is fairly limited, especially utf8_general_ci. You might want to switch to utf8_unicode_ci or utf8mb4

What's the difference between utf8_general_ci and utf8_unicode_ci

http://mathiasbynens.be/notes/mysql-utf8mb4

edited May 23 '17 at 12:13

Community

1
1

answered Oct 09 '13 at 20:30

Machavity

30,841
27
92
100

score 0 · Accepted Answer · answered Aug 25 '16 at 11:48

Hei,

Firstly be sure you have this meta in html tag

<meta charset="UTF-8">

You can check also with this line in php, above you mysql extraction

header('Content-type: text/html; charset=utf-8');

If you store your special character in database as html code like this ' which is ' when you extract try to use this php function

htmlspecialchars_decode($your_text_from_db);

UTF8 mysql encoded database, but not showing special characters in PHP

3 Answers3

Linked