Our system locale import/export is set to UTF-8.
When we generate a report (web view), we can see Chinese characters.
But when exporting the report to csv, the field with Chinese field shows β???β
Is there a way to just use SuiteCRM API to export the report as is since I can view the Chinese characters on web?
Hello Noel,
here, itβs working just fine.
Chinese characters in the fields = Chinese characters in the CSV export as well.
How does your profile setting look like?
Works here via list view export and via reports export:
Maybe additionally: Double check the CSV file with Notepad++ or some other editor (just to rule out Excel / Spreadsheet software).
1 Like
Thanks. I tried to view it on notepad++ but only shows question marks.
Iβm using docker version of suitecrm 8 from Bitnami. Did you do any manual setting on PHP for some type of encoding ?
May I know what you have for the settings below?
You solved my problem. I had not set the encoding in my profile. Thank you so much!