Skip to Content.
Sympa Menu

freetds - Re: [freetds] empty strings select as null bug

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Geoff Montee <geoff.montee AT gmail.com>
  • To: jklowden AT freetds.org, FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] empty strings select as null bug
  • Date: Wed, 10 Jun 2015 20:46:26 -0700

On Wed, Jun 10, 2015 at 7:07 PM, James K. Lowden
<james.k.lowden AT icloud.com> wrote:
>
> Using dbdatlen, you cannot distinguish between a zero-length string and
> NULL. In some versions of TDS, there is no difference between the
> two: at the protocol level, a NULL CHAR column was indicated by having
> a length of zero. Later versions indicated NULL explicitly. That
> opened the possibilty of a non-NULL CHAR field having no data, a very
> strange situtation indeed.
>
> IIRC NULL can be more accurately detected with dbnullbind.
>

If this true, then it sounds like Jeff's bug is in my code. I think I
can work with dbnullbind.

Thanks, James!

Geoff




Archive powered by MHonArc 2.6.24.

Top of Page