Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
malradi88
Creator II
Creator II

MySQL connector fields returning 'System.Byte[]'

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, 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
1 Reply
congtv
Contributor II
Contributor II

I'm having the same problem and can't find a better way than using CONVERT(field, char) as Field