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

[d-schmidt]

Hi, I had this Error when using QvODBCConnectorPackage in QlikView and trying to Select a timestamp-Field (The data type "timestamp" is kind of a binary value and has nothing to do with DateTime or Time) from a MSSQL-Database.

Unfortunately every table in the database has a timestamp field in it. So SELECT * was not possible without getting above Error-Message in the connector log.

In the install folder of the connector package there is a config file, which lets you specify how different data types are interpreted by the connector.
C:\Program Files\Common Files\QlikTech\Custom Data\QvODBCConnectorPackage\qlikview.qliksourceconfig

Here I found the node <SourceConfiguration id="mssql" displayName="Microsoft SQL Server"> and within this node there are all TypeMappings to be found.
For the SourceType "timestamp" I changed the QvxFieldType from "Time" to "String". 

Now the error is gone, but in QV now every value in the timestamp fields is 'System.Byte[]'. 

We don't need the field anyway. But at least for our QV legacy QVD generators SELECT * is working again. 😄

Cheers!