Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

abhaysingh
Contributor III

How to read Binary data from database Table

Hi guys,

I have to read binary data from database itself, like some data is converted into binary and stored in database tables,

i need to fetch this data into qlik and convert this data to tabular format.

i am attaching the sample data as well.

Please suggest.

Field name is

PublishedPDF

thanks in advance

regards

Abhay singh

2 Replies
balabhaskarqlik
Honored Contributor

Re: How to read Binary data from database Table

Try like these scenarios:

load binary in mysql load using HEX() function like this:

LOAD ...;

SQL SELECT

     HEX(Id) as Id,

     Name,

FROM table01;

OR

ODBC CONNECT TO [PetesDFM;DBQ=xe] (XUserId is eLNcfZFPTDdKWWZK, XPassword is eSfTSSRNMLaeGaROCE);

PeteDFM:

SQL SELECT IAMGE,

   IMAGETYPE

FROM SYSTEM.QLIKVIEWIMAGES;

//info select imagetype, iamge from system.qlikviewimages;//-------- Start Multiple Select Statements ------

INFO SELECT IMAGETYPE, IAMGE FROM SYSTEM.QLIKVIEWIMAGES;

Refer this:

https://community.qlik.com/message/651608#651608

abhaysingh
Contributor III

Re: How to read Binary data from database Table

Hi Bala  Thanks for reply,,.

tried this ,,,

LOAD ...;

SQL SELECT

     HEX(Id) as Id,

     Name,

FROM table01;

but its not working...

can you suggest this how i can use this ?

ODBC CONNECT TO [PetesDFM;DBQ=xe] (XUserId is eLNcfZFPTDdKWWZK, XPassword is eSfTSSRNMLaeGaROCE);

PeteDFM:

SQL SELECT IAMGE,

   IMAGETYPE

FROM SYSTEM.QLIKVIEWIMAGES;

//info select imagetype, iamge from system.qlikviewimages;//-------- Start Multiple Select Statements ------

INFO SELECT IMAGETYPE, IAMGE FROM SYSTEM.QLIKVIEWIMAGES;

thanks

Community Browser