https://ilikekillnerds.com/2014/08/fixing-sequel-pro-sql-encoding-error-for-imported-sql-files/
The fix: When importing your database dump, you need to select Western (Mac OS Roman) as the encoding format for the file to import without issue.