freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
- 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
-
Patch for convert.c,
Frediano Ziglio, 08/04/2002
- <Possible follow-up(s)>
- Re: Patch for convert.c, James K . Lowden, 08/04/2002
- Re: Patch for convert.c, Frediano Ziglio, 08/04/2002
Archive powered by MHonArc 2.6.24.