113 views

Some CSV editors need to import Unicode CSV files by explicitly specifying the Unicode encoding

Problem

Some CSV editors (for example, Excel), if not correctly used, display characters such as question marks "?" in place of other characters (for example, "") when opening Unicode CSV files.

Symptoms


When you export to CSV, for some users, some characters appear as "?" (question mark).

Cause


CSV files are not Unicode safe. Some Unicode editors open in non-Unicode character sets. If the character set is incorrect, the unrecognized characters can display as question marks "?". This problem can occur if you have set the glide.export.csv.charset system property value to UTF-8.

Resolution


If the operating system is Unicode safe, use the appropriate setting when opening the file to open Unicode files correctly. For example, in Excel, open the file by explicitly specifying the Unicode encoding on the "open dialog".

To ensure that the Unicode CSV file is opened correctly:

  1. Set the glide.export.csv.charset system property value to UTF-8.
  2. Ensure that the operating system supports the Unicode characters used.

Check whether the CSV editor opens the file in Unicode.

 

Article Information

Last Updated:2018-01-12 11:53:52
Published:2017-09-26