Character encoding issue in mysql

Question

In my database, I have some content like this

അവരുടെ മനസ്സുകളില്‍.

But, when i am trying to fetch the content using PHP and display it in broswer, it is showing only some question marks like ????????? ???????. ??????.

I tried to set the content type header like this

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

But it doesnt work.

How can i solve this ? any help would be greatly appreciated.

Marcin Orlowski · Accepted Answer · 2013-04-07 15:13:35Z

2

It does not work because you got this broken during data fetch and you are setting display encoding - it's already too late. Simply ensure correct encoding during connection by using either using proper method like mysqli_set_charset() or do query SET NAMES UTF8 just after your connect to DB

answered Apr 7, 2013 at 15:13

Marcin Orlowski

75.7k11 gold badges128 silver badges152 bronze badges

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

Comments

juco · Accepted Answer · 2013-04-07 15:17:53Z

1

Depending on the method you are using to connect to the DB, you should be specifying the charset.

With PDO, you can specify the charset in PDO::__construct(), such as: charset=UTF-8

Otherwise you have mysqli::set_charset() for MySQLi, or god forbid you're still using mysql_* functions there's mysql_set_charset()

answered Apr 7, 2013 at 15:17

juco

6,3423 gold badges27 silver badges42 bronze badges

Collectives™ on Stack Overflow

Character encoding issue in mysql

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related