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: James K. Lowden <jklowden AT speakeasy.org>
  • To: "TDS Development Group" <freetds AT franklin.oit.unc.edu>
  • Subject: Re: Patch for convert.c
  • Date: Sun, 4 Aug 2002 13:06:21 -0400


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




Archive powered by MHonArc 2.6.24.

Top of Page