FYI for the group, I can confirm that this appears to work correctly and in an automatic fashion.
Thanks, Sergey. -Jon -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Sergey Soldatov Sent: Wednesday, March 30, 2016 9:11 AM To: [email protected] Subject: Re: [EXTERNAL] Re: How to use VARBINARY with CsvBulkLoadTool 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
