Export - XLS and Google Sheet: Wrong Encoding !

[michabbb]

dear support,

when exporting utf8mb4 data (that contains german umlauts) or a "ß" for instance,
the exported data to XLS,XLSX and google sheets is wrong - the exported data looks like latin1 or
whatever, but it´s not UTF8 - please fix !

thanks

Version: enterprise 9.0.791

[alexa]

In order to resolve this issue, please select the utf8 encoding in the 'Encoding' drop-down menu on the 'Advanced' tab of the Database Connection Properties dialog box that can be invoked by right-clicking the connection in Database Explorer and selecting 'Modify Connection...' from the popup menu

[michabbb]

hi alex,

i already have - of course !
i am working with a utf8mb4 database so my connection is to this encoding.
that is not the problem, that´s why I believe it´s a bug.

cheers,
micha

[alexa]

Thank you for the reply.

We will investigate this issue.

[alexa]

Unfortunately, we were not able to reproduce this issue.

Could you please provide us the result of the following queries:
SHOW VARIABLES LIKE '%char%';
SHOW VARIABLES LIKE '%collat%';

Please also provide us a screenshot of the Advanced page of the Database Connection Properties dialog box.

Additionally, please provide us a screenshot of the result and the exported file.

[michabbb]

hi alex,

i guess i found the problem here: the field that makes problems here is of type "VARBINARY".
when showing data in the data-explorer, everything gets displayed correctly. i do understand,
that VARBINARY is not VARCHAR, but when it comes to exports, it would make sense to handle it
like VARCHAR.

or it would make sense in the export options to add a checkbox: "convert VARBINARY to VARCHAR".

thanks,
micha

[alexa]

Thank you for the reply.

We will investigate this issue.