Fixing Sequel PRO SQL Encoding Error For Imported SQL files

Glasses in front of monitor

I use Sequel Pro for administering databases on local development environment.

I encountered an error where the database import would reach half way and the importing process prompts an error  about the encoding being incorrect. Although the database file was encoded in UTF-8 and it seems that the autodetect failed and does not work.

There seems to be an encoding mismatch when exporting a MySQL database from a Linux environment and then imported into Sequel Pro on Mac.

Fixing Sequel PRO SQL Encoding Error

When importing your database in Sequel Pro, select Western (Mac OS Roman) as the encoding format for the file to import to fix the issue.

Add new comment

Plain text

  • No HTML tags allowed.
  • Lines and paragraphs break automatically.
  • Web page addresses and email addresses turn into links automatically.