Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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.