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 <[email protected]> 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: [email protected] [mailto:[email protected]] On Behalf > Of Sergey Soldatov > Sent: Tuesday, March 29, 2016 5:00 PM > To: [email protected] > 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 <[email protected]> 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
