Support Article
Data exported as CSV does not support Thai characters
SA-81578
Summary
A table is delegated for business and the Export and Import CSV is used as the main feature. On downloading the file from the Pega application, Thai characters display incorrectly.
Error Messages
Not Applicable
Steps to Reproduce
- Create a table using the Data Table wizard.
- Input Thai characters in the table.
- Export the table using the Export link.
- Open the CSV file in Microsoft Excel.
Root Cause
Thai characters did not display due to encoding issues.
Resolution
Here's the explanation for the reported behavior:
Microsoft Excel does not allow the data to be saved as a CSV file in Unicode. The data must be saved as Unicode text and all the tabs with commas (,) must be converted using a Text editor such as Notepad++.
To leverage the existing functionality, edit using Text editor such as Notepad++ instead of using Excel to edit data with multi-byte characters.
Additionally, to view the exported data in Excel, perform the below steps instead of opening the file directly in Excel,
- Open Excel file.
- Navigate to the Data tab.
- Obtain the external data in XML format.
- Select the file.
- Select the Delimiter option as comma and import it. Thai characters display correctly in Excel.
Published August 19, 2019 - Updated December 2, 2021
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.