bcp_bind with NVARCHAR with FreeTDS 1.00.15

Joshua Lang <[email protected]> Tue, 1 Nov 2016 16:33:31 -0700
Newsgroups gmane.comp.db.tds.freetds
Message-ID <CAFTwDJSq_tOwh4ciB7sftxnj4QMPfGMsqYCk-5vzPTZ19uZqBg@mail.gmail.com>
I'm have issues using the programmatic bcp APIs and a table with an
NVARCHAR column.

If I specify a data type of NVARCHAR (0xe7) to bcp_bind's db_vartype
parameter, bcp_sendrow fails in tds_convert since there is no conversion
for the NVARCHAR type supported by tds_convert. This fails with an error of
"Requested data conversion does not exist", though this error is generated
internally from FreeTDS.

If I specify VARCHAR as the data type, the server rejects the input data
with an error of
"Unicode data is odd byte size for column 4. Should be even byte size."

Any ideas?