1 Reply Latest reply: Aug 5, 2015 11:03 AM by Zhihong He RSS

    load mysql table with binary field

    Zhihong He

      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