UTF8 encoding issue?

Question

I am having a problem with characters á, Á, ó, Ó, ú, Ú, í, Í, é, É being stored in our mysql DB as strange characters. We are using PDO for inserting to the DB.

The odd this is that I have a local copy of the site on my computer on WAMP which all works fine, and there is no encoding issue. The live site is on a Linux server, if that possibly makes a difference.

The local DB is a copy of the live DB, so all the encoding is the same in all of the tables.

I have tried setting the PDO encoding:

$pdo = new PDO('mysql:host=' . Settings::DBHostName() . ';charset=utf8;dbname=' . Settings::DBName(), Settings::DBUsername(), Settings::DBPassword(), array( PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION ));

Any other suggestions? I can't see why it would work locally and not on our live site?

PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8" seems to fix it. — DecoK
– DecoK, Commented Mar 14, 2013 at 11:15
You want utf8mb4, nothing less, SET NAMES utf8mb4 read all about why this is the way — Mm-Art-In
– Mm-Art-In, Commented Jul 31, 2017 at 15:32

Your Common Sense · Accepted Answer · 2013-03-14 11:28:12Z

1

For the PHP versions since 5.3.6 you should set the encoding in DSN.
For all others to issue a conventional SET NAMES query is the only choice.

answered Mar 14, 2013 at 11:28

Your Common Sense

158k42 gold badges226 silver badges374 bronze badges

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

Comments

pedram shabani · Accepted Answer · 2017-07-31 15:28:52Z

0

The last parameter of the PDO constructor call is the driver specific options, given as an array with key => value pairs. The MySQL driver has a PDO::MYSQL_ATTR_INIT_COMMAND option where you can specify a command that is executed every time you connect to the database.You can use the MySQL specific query SET NAMES utf8 as a value for the init command, to tell MySQL to use UTF-8 as the character set for our connection.

$pdo = new PDO('mysql:host=mysql.host.com;dbname=db;array(PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8"', 
'database', 'password');

edited Jul 31, 2017 at 15:28

answered Jul 31, 2017 at 13:04

pedram shabani

1,6903 gold badges20 silver badges32 bronze badges

Collectives™ on Stack Overflow

UTF8 encoding issue?

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related