Reports show Chinese characters but not in exported csv

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:

image

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 ?

image

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!

Glad that it worked. :slight_smile: