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.
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.
- In the DB scheme.
- For DB connection itself.