Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

Chinese Character Not Supported

Tyris's profile image Tyris posted 3 years ago in Import/Export Permalink

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.

1 attachment(s):
  • Untitled-1
ansgar's profile image ansgar posted 3 years ago Permalink

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

Tyris's profile image Tyris posted 3 years ago Permalink

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.