Character Encoding: UTF-8, PHP, MySQL and Sequel Pro

I love Sequel Pro. However, the default encoding is latin1 and you should really be using a form of Unicode like utf8mb4. The next time you add a database with Sequel Pro be sure to select UTF-8 Unicode (utf8mb4) if you want to skip character encoding headaches.

sequal-pro-utf8mb4

 

Make proper character encoding a priority and understand how character encoding works. There is a PHP Roundtable on UTF-8 Encoding that will get you started.

When and where to set UTF-8 Encoding

There are a number of place to set the character encoding for a PHP web application.

  • In your HTML forms.
  • HTML meta tag.
  • HTTP Content-Type header
  • In the DB scheme.
  • For DB connection itself.