System.Byte[]' as field text when connecting to MySQL via Qlik enterprise MySQL connector

[malradi88]

To Whom it May Concern,

I hope this finds you well.  A colleague and I created a connection between a Qlik enterprise app and a MySQL database (phpMyAdmin). The connector works (the MySQL connector made available in Qlik Enterprise), but for some reason all the data under fields (except for the date field) come back as 'System.Byte[]' even though it's text.My colleague told me that the data is in utf8mb4_unicode_ci. 

Is this a problem any of  you have encountered before? If so is there any quick fix to it? (I tried putting text() around the fields as well but same problem.. )

Thank you for your time and support.

Best,

Mohammed

[victor1]

Did you find an answer to this? I'm having the same issue

[iulianne83]

You could use Convert(FIELD, char) AS FIELD.

It is not a nice solution but it may be the only, except using ODBC.

[congtv]

me too. All the text fields are returned in system.byte[]. It's time-consuming to use convert all the time.

[congtv]

Found this link:

https://community.qlik.com/t5/New-to-Qlik-Sense/Qliksense-connector-for-Mysql-Community-Edition/td-p...