Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

geminihzh
Valued Contributor

load mysql table with binary field

Hi, all,

May I know how to correctly load mysql table with binary column?

I need to use a table from a database implemented by a college, and found that one column is binary data.

After a normal "LOAD", this binary column is empty for some rows. Have no idea why. Dose any one knows about this?

Though I solved the problem as the reply below, but I do not understand why only some rows get "empty" data. It seems not null, as I use isNull() condition to check the value, it still get an empty column.

Thanks very much

Zhihong

Tags (1)
1 Solution

Accepted Solutions
geminihzh
Valued Contributor

Re: load mysql table with binary field

Hi, all,

I solved the problem by first load binary in mysql load using HEX() function like this:

LOAD ...;

SQL SELECT

     HEX(Id) as Id,

     Name,

FROM table01;

1 Reply
geminihzh
Valued Contributor

Re: load mysql table with binary field

Hi, all,

I solved the problem by first load binary in mysql load using HEX() function like this:

LOAD ...;

SQL SELECT

     HEX(Id) as Id,

     Name,

FROM table01;

Community Browser