Re: bcp_bind with NVARCHAR with FreeTDS 1.00.15

Joshua Lang <[email protected]> Thu, 3 Nov 2016 16:01:52 -0700
Newsgroups gmane.comp.db.tds.freetds
Message-ID <CAFTwDJS8YL-DpbG+nER+UMaCqLEkOBqSHSgcL_sctXWuwSXP1w@mail.gmail.com>
As currently implemented, it would appear not.

Should I open an issue on github for this to be fixed?

On Wed, Nov 2, 2016 at 8:32 AM, Frediano Ziglio <[email protected]> wrote:

> 2016-11-01 23:33 GMT+00:00 Joshua Lang <[email protected]>:
> > 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?
>
>
> I was looking at the code. Maybe this conversion is not much supported
>
> Frediano
> _______________________________________________
> FreeTDS mailing list
> [email protected]
> http://lists.ibiblio.org/mailman/listinfo/freetds
>