Hello.
May I know how to import Chinese character via .SQL file?
Whenever I tried to import it by HeidiSQL. It keeps showing unknown character.
My database is using utf8_unicode_ci.
When loading a .sql file, you should always set the right encoding in the file-open-dialog. Do not rely on "Auto-detect".
Also, in the data grid, use a font which can display chinese characters, per Tools > Preferences > Editor
Thanks Ansgar,
That fixed my problem.
Please login to leave a reply, or register at first.