System.Byte[] Error when Loading Binary Data Type

[Sonja_Bauernfeind]

The error System.Byte[] was occurring when attempting to load data from a binary data type column from MS SQL Server database.

Environment:
Qlik Sense Enterprise on Windows any version

Resolution:

This issue was resolved by creating a new column in the SQL Server database and converting the column to be varchar data type. Then this new varchar column could be read into Qlik Sense without any error.

This type of conversion function was used in the database in the process to create the new column:
Convert(NVARCHAR(MAX), "FieldName", 1) as Varchar_FieldName.

See Data Types for available Data Types in Qlik Sense. 

[janyf]

I was able to extract varchar(max) binary as base64  into qlik via this select 

select id,
cast('' as xml).value(
'xs:base64Binary(sql:column("tbl_data.BINARYDATA"))', 'varchar(max)'
) as Data_binary
from "db".dbo."tbl_data";