I love Sequel Pro. However, the default encoding is latin1 and you should be using a form of Unicode like utf8mb4 and utf8mb4_unicode_ci. 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.

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. You can also watch this video about UTF8.

When and where to set UTF-8 Encoding

There are many places 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.