Character encoding php mysql

Question

I have a table where the data are stored like boÃ®tes with none utf8 characters. Now I have my php script which works fine on my local machine.

$utf = utf8_decode($details);
echo "UTF8-DE : ".$utf."<hr>";-> `boîtes`

When I put this script on another machine its not working its echoing boÃ®tes . I am sure it depends on the charset of the php or server? Any help please

Bora · Accepted Answer · 2013-08-22 07:27:47Z

1

Try set_charset function

For mySqli

mysqli_set_charset($connection, "utf8");

For mySql

mysql_set_charset("UTF8", $connection);

Alternative

mysql_query("SET NAMES 'utf8'");
mysql_query("SET CHARACTER SET utf8");
mysql_query("SET COLLATION_CONNECTION = 'utf8_unicode_ci'");

answered Aug 22, 2013 at 7:27

Bora

10.7k5 gold badges50 silver badges76 bronze badges

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

Comments

Young Student · Accepted Answer · 2013-08-22 07:21:51Z

1

Set it up with headers

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

answered Aug 22, 2013 at 7:21

Young Student

1319 bronze badges

Collectives™ on Stack Overflow

Character encoding php mysql

2 Answers 2

For mySqli

For mySql

Alternative

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

For mySqli

For mySql

Alternative

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related