Re: empty strings select as null bug

On Wed, Jun 10, 2015 at 7:07 PM, James K. Lowden
<[email protected]> 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