Hi Jon, At least it's supposed to work in that way :) VARBINARY uses Base64.decode for String values.
Thanks, Sergey On Tue, Mar 29, 2016 at 7:57 PM, Cox, Jonathan A <ja...@sandia.gov> wrote: > Hi Sergey, > > Thanks for getting back to me. So if I simply place base64 encoded ASCII in a > column that maps to a VARBINARY in the table, it will automatically interpret > it as base64 and decode/store it? I don't have to specify that my CSV file > contains base64? > > Thanks, > Jon > > -----Original Message----- > From: sergey.solda...@gmail.com [mailto:sergey.solda...@gmail.com] On Behalf > Of Sergey Soldatov > Sent: Tuesday, March 29, 2016 5:00 PM > To: user@phoenix.apache.org > Subject: [EXTERNAL] Re: How to use VARBINARY with CsvBulkLoadTool > > Hi Jon, > Base64 is supposed to be. > > Thanks, > Sergey > > On Tue, Mar 29, 2016 at 12:38 PM, Cox, Jonathan A <ja...@sandia.gov> wrote: >> I am wondering how I can use the CsvBulkLoadTool to insert binary data >> to a table. For one thing, which format does CsvBulkLoadTool expect >> the data to be encoded as within the CSV, when inserted into a VARBINARY >> type? Hex? >> Base64? Something else? Is there a way to choose or specify? >> >> >> >> Thanks, >> >> Jon