[freetds] dbbind funny

James K. Lowden jklowden at schemamania.org
Fri Jun 11 18:30:28 EDT 2004


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



More information about the FreeTDS mailing list