When exporting information in Chinese in Adhoc or the Online Report designer, the output is unreadable.
Chinese characters are not compatible with CSV when exported directly.
The CSV file already contains the correct characters, but it is not being displayed properly by Microsoft Excel.
Instead of opening the CSV file directly in Excel, follow these steps:
- Open a blank Excel workbook
- Go to Data > From Text > select the CSV file > Import
- Under "File Origin" select UNICODE (UTF-8) > Finish > OK
Adhoc, Adhoc report export, Chinese export, CSV , KBA , LOD-SF-ANA-ADH , Adhoc Reports & Report Builder , How To