Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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