I selected the file to select UTF-8. The foreign characters appeared normally.
Interesting, if I did not select the file to enable the option of encoding, the foreign characters would not be working. (I mean I open it with Sequel Pro from Finder or I drag it on the app at the dock, I have to open Sequel Pro to open a file).
There is still an issue. If I select File ➜ Open Recent ➜ SQL file, the foreign characters will not work.
changed the title from
The setting for manual charset is not retained when opening a file via "Open Recent"
The setting for manual charset is not retained when re-opening a file via "Open Recent"Oct 14, 2018