Some CSV editors need to import Unicode CSV files by explicitly specifying the Unicode encoding
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.
When you export to CSV, for some users, some characters appear as "?" (question mark).
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.
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:
- Set the glide.export.csv.charset system property value to UTF-8.
- Ensure that the operating system supports the Unicode characters used.
Check whether the CSV editor opens the file in Unicode.