Chinese Character Not Supported

[expired user #9972]'s profile image [expired user #9972] posted 8 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 8 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

[expired user #9972]'s profile image [expired user #9972] posted 8 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.