SET NAMES utf8 in MySQL?

php mysql utf-8
JasonDavis picture JasonDavis · Jan 29, 2010 · Viewed 376.3k times · Source

I often see something similar to this below in PHP scripts using MySQL

query("SET NAMES utf8");

I have never had to do this for any project yet so I have a couple basic questions about it.

  1. Is this something that is done with PDO only?
  2. If it is not a PDO specific thing, then what is the purpose of doing it? I realize it is setting the encoding for mysql but I mean, I have never had to use it so why would I want to use it?

Answer

Vinko Vrsalovic picture Vinko Vrsalovic · Jan 29, 2010

It is needed whenever you want to send data to the server having characters that cannot be represented in pure ASCII, like 'ñ' or 'ö'.

That if the MySQL instance is not configured to expect UTF-8 encoding by default from client connections (many are, depending on your location and platform.)

Read http://www.joelonsoftware.com/articles/Unicode.html in case you aren't aware how Unicode works.

Read Whether to use "SET NAMES" to see SET NAMES alternatives and what exactly is it about.

Related questions

UTF-8 all the way through

I'm setting up a new server and want to support UTF-8 fully in my web application. I have tried this in the past on existing servers and always seem to end up having to fall back to ISO-8859-1. Where …

Read More
Fixing broken UTF-8 encoding

I am in the process of fixing some bad UTF-8 encoding. I am currently using PHP 5 and MySQL. In my database I have a few instances of bad encodings that print like: î The database collation is utf8_general_ci PHP …

Read More
Storing and displaying unicode string (हिन्दी) using PHP and MySQL

I have to store hindi text in a MySQL database, fetch it using a PHP script and display it on a webpage. I did the following: I created a database and set its encoding to UTF-8 and also the collation …

Read More