I have a varbinary(max) column that I need to bulk import. The data I'm putting into this column is a byte in C#. How do I format the data in the comma-delimited file used for bulk import? In other words, how do I convert from a byte to a string in a way the bcp utility will accept?
- Anybody can ask a question
- Anybody can answer
- The best answers are voted up and rise to the top
A varbinary value is of the form
So your CSV would be
Edit May 2013,
After testing, I can't get this to work with BULK INSERT with or without a format file.
I will post something more when I get it working. I can't delete this answer
You can use the BCP unicode native format to import/export. Use
I got it to work. Your varbinary data must be in form
I have the following table:
and bulk import query:
It works nice for the csv file with windows-1251 encoding:
Here the value