MySQL’s UTF-8 charset doesn’t fully support Unicode

Insightful and detailed article by the fantastic Mathias Bynens on how to guarantee your MySQL database will accept any unicode character you throw at it.

“For a long time, I was using MySQL’s utf8 charset for databases, tables, and columns, assuming it mapped to the UTF-8 encoding… By using utf8, I’d be able to store any symbol I want in my database — or so I thought.”

—execerpted from How to support full Unicode in MySQL databases, by Mathias Bynens.