freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
- From: "James K. Lowden" <jklowden AT schemamania.org>
- To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
- Subject: Re: [freetds] dbbind funny
- Date: Fri, 11 Jun 2004 18:30:28 -0400
On Fri, 11 Jun 2004, "Thompson, Bill D (London)" <bill_d_thompson AT ml.com>
wrote:
> > There's another bugaboo in this neighborhood that'd be nice to fix.
> > When freebcp encounters a data conversion error, its most common
> > message is 20073 (Attempt to bulk-copy a NULL value).
> > What's happening is that dbconvert() fails, meaning that destlen is 0,
> >
> > causing the "converted" data to be nil, which is then sent to the
> > server.
>
> > The server obviously sees zero-length data as null, and complains.
> > Unless the column is nullable, that is, in which case you, er, merely
> lose your data.
>
> Not any more, my friend.
> A conversion error is now reported as such.
> The "Attempt to bulk-copy a NULL..." message now only occurs in genuine
> circumstances.
> In neither case do the rows of data get anywhere near the server...
Have I mentioned lately how very much I like you? I look forward to your
patch.
I think I'll be quiet for a while and write some documentation or
something....
--jkl
-
[freetds] dbbind funny,
Thompson, Bill D (London), 06/10/2004
- <Possible follow-up(s)>
- RE: [freetds] dbbind funny, Lowden, James K, 06/10/2004
- RE: [freetds] dbbind funny, Thompson, Bill D (London), 06/11/2004
-
RE: [freetds] dbbind funny,
Thompson, Bill D (London), 06/11/2004
- Re: [freetds] dbbind funny, James K. Lowden, 06/11/2004
Archive powered by MHonArc 2.6.24.