utf8 encoding is not working correctly in php

Question

I am using a magazine name listing program using php. Here I used to manipulate different languages.

I am inserting magazine name into a table. The field name is

 tbl_magazine field type - varchar(32 collation utf8_general_ci

when I insert different languages into the table [using google translator]. This correctly inserted into my db [like this viewing in database সঙ্গে পরীক্ষা]. But when I retrieve this using php this record show as ????? like this.

If anyone know about this, please help me.

Can you show the code which retrieves it from database, and outputs it? Is your file encoded as utf-8? Also, is your webserver serving utf-8? — dkasipovic
– dkasipovic, Commented Mar 6, 2014 at 10:55
If you're sure database is dealing right with the text, you need to post the string in codes to examine what's happening. — Gustavo
– Gustavo, Commented Mar 6, 2014 at 21:26

Kapitein Witbaard · Accepted Answer · 2014-03-06 11:00:15Z

Set your database connection to UTF8:

mysql_query("SET CHARACTER SET UTF-8", $conn); mysql_query("SET NAMES UTF-8", $conn);

Also ensure your HTTP responses are interpreted as UTF8:

header("Content-Type: text/html; charset=UTF-8");

Balaji Kandasamy · Accepted Answer · 2014-03-06 10:58:35Z

Try to use this code at top of your page,

mysql_query('SET character_set_results=utf8');

For more details, you can refer this tutorial, http://www.9lessons.info/2011/08/foreign-languages-using-mysql-and-php.html

user1844933 · Accepted Answer · 2014-03-06 10:54:49Z

0

first your db table must have utf8_general_ci collation

and place mysqli_set_charset ($con, "utf8"); after connection establish...

answered Mar 6, 2014 at 10:54

user1844933

3,4132 gold badges28 silver badges44 bronze badges

1 Comment

eggyal Over a year ago

Who said the OP was using mysqli?

Eternal1 · Accepted Answer · 2014-03-06 10:56:00Z

0

Try executing the following query before you retrieve data:

SET NAMES utf8

It should help.

answered Mar 6, 2014 at 10:56

Eternal1

5,6253 gold badges34 silver badges48 bronze badges

Collectives™ on Stack Overflow

utf8 encoding is not working correctly in php

4 Answers 4

1 Comment

1 Comment

1 Comment

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

1 Comment

1 Comment

Comments

Linked

Related