Selecting Character Encoding for a File

Article Number:020140

Select a suitable character encoding for a text file when exporting data such as users and departments.

Screenshot: A screen to import a file. The "Character Encoding" box is displayed.

Consider the following points to select the suitable character encoding.

  • The character types within the data contained in the file
  • The supported character encodings by your editing software, when editing exported files
  • The supported character encodings by another system, when importing the exported files into the system

When the Exported Files Are Garbled

If characters are garbled when you open the exported file, refer to the following to select a suitable character encoding.

UTF-8

UTF-8 is a character encoding capable of representing the character types for major languages.
Select "UTF-8" as the character encoding if the data to be exported contains Traditional Chinese characters or any of the following.

  • Variant characters such as "髙" (U+9AD9) and "會" (U+6703)
  • Special characters such as the copyright symbol (©) and the registered trademark (®)
  • Emoji

Shift-JIS

If you want to use Excel to edit the exported file that contains some Japanese characters, select "Shift-JIS" when you export the file.
You may also select "Shift-JIS" if you want to edit such exported file by a text editor.

Latin1

You can select "Latin1" if you want to edit the exported file that contains some Western European characters (including English, French, and German).

GBK/GB2312

You can select "GBK/GB2312" if you want to edit the exported file that contains some Simplified Chinese characters.