Skip to Content.
Sympa Menu

freetds - Re: Patch for convert.c

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Frediano Ziglio <freddyz77 AT tin.it>
  • To: TDS Development Group <freetds AT franklin.oit.unc.edu>
  • Subject: Re: Patch for convert.c
  • Date: 04 Aug 2002 19:27:20 +0200


Il dom, 2002-08-04 alle 19:06, James K.Lowden ha scritto:
> On 04 Aug 2002 17:13:04 +0200, "Frediano Ziglio" <freddyz77 AT tin.it> wrote:
>
> > note on point 2. Is correct to convert integer != 0 to bit 1 or is best
> > to return fail ?
>
> It is better to do what the vendors do. Here's Sybase's isql:
>
> 1> select @@version
> 2> , convert(bit, -1), convert(bit, 0), convert(bit, 1), convert(bit,2)
>
> ------------------------------------ - - - -
> Adaptive Server Enterprise/11.9.2.3 1 0 1 1
>
> (1 row affected)
>
> It looks to me like any non-zero integer becomes 1.
>
> --jkl
>
Well, so patch is correct (bit act like a boolean type, not integer)

freddy77






Archive powered by MHonArc 2.6.24.

Top of Page