CSV Export charset Fail

Charset conversion to UTF8 by database is set to Yes

The Grid show the information correctly

image

The XML also show the information correctly

image

Same thing for Excel, PDF, JSON

But CSV is wrong

image

Is there anyway go around this bug

A few options:

  • Your database is not set up for UTF8, but ISO
  • Your application already uses UTF8 and you are double converting it
  • There is a bug in the CSV export, then you must address SC

I expect it to be a bug, but perhaps the other options might be applicable. The only way to really find out is to look at the generated sourcecode. But that’s a burdon.

Thank you,

My DB charset is utf8mb4_unicode_ci and the app ISO-8859-15, it’s working fine in all the apps and all the export option except the CSV option. Even the title of the column is wrong in CSV

About SC support, I open 12 paid tickets last November,
3 - are still unanswered
3 - were close for inactivity (they ask for more information, I supply it the same day and after waiting for 3 or 4 months they simply close them for inactivity even if they are the one doing nothing)
4 - were already know problem, 3 of them are now fix
2 - were fix in about 1 month delay

1 Like

Looks like a bug then. Regarding support, that’s a known issue, unfortunately. Have been discussing this often here, so no need for repetition :frowning:

    :cry: