Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
malradi88
Creator II
Creator II

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

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
Labels (2)
4 Replies
victor1
Contributor
Contributor

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

iulianne83
Contributor
Contributor

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

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

congtv
Contributor II
Contributor II

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