phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Cox, Jonathan A" <>
Subject RE: [EXTERNAL] Re: How to use VARBINARY with CsvBulkLoadTool
Date Wed, 30 Mar 2016 02:57:38 GMT
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?


-----Original Message-----
From: [] On Behalf Of Sergey Soldatov
Sent: Tuesday, March 29, 2016 5:00 PM
Subject: [EXTERNAL] Re: How to use VARBINARY with CsvBulkLoadTool

Hi Jon,
Base64 is supposed to be.


On Tue, Mar 29, 2016 at 12:38 PM, Cox, Jonathan A <> 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
View raw message