Skip to main content
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT

System.Byte[] Error when Loading Binary Data Type

No ratings
Showing results for 
Search instead for 
Did you mean: 
Digital Support
Digital Support

System.Byte[] Error when Loading Binary Data Type

Last Update:

Oct 28, 2021 3:39:42 AM

Updated By:


Created date:

Apr 9, 2019 10:14:48 AM

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

Qlik Sense Enterprise on Windows any version


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. 

Labels (1)
Partner - Contributor III
Partner - Contributor III

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";

Version history
Last update:
‎2021-10-28 03:39 AM
Updated by: