Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
valentin_lhomme
Contributor II
Contributor II

Load data from MySQL with MySQL Connector

Hello,

After loading data from a table, all string data are visible as System.Byte[], only date and int type are visible.

Does anybody know how to solve that issue ?

Capture d’écran 2018-07-20 à 15.18.00.png

Valentin

1 Solution

Accepted Solutions
valentin_lhomme
Contributor II
Contributor II
Author

I resolved the issue doing the solution given here Qliksense connector for Mysql Community Edition?

Be careful with native Qlik connector, I installed Qlik-ODBC-connector before and then uninstalled it to retreive default Qlik Sense connector, but they disappeared during the operation.

View solution in original post

2 Replies
valentin_lhomme
Contributor II
Contributor II
Author

It appears to be because of data interclassement format which is utf8mb4_bin that I am unfortunately authorised to modify.

valentin_lhomme
Contributor II
Contributor II
Author

I resolved the issue doing the solution given here Qliksense connector for Mysql Community Edition?

Be careful with native Qlik connector, I installed Qlik-ODBC-connector before and then uninstalled it to retreive default Qlik Sense connector, but they disappeared during the operation.