freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Re: BIT type return from SQL SERVER 2000 need truncate

From: Frediano Ziglio <freddyz77 AT tin.it>
To: TDS Development Group <freetds AT franklin.oit.unc.edu>
Subject: Re: BIT type return from SQL SERVER 2000 need truncate
Date: 16 Aug 2002 11:16:17 +0200

Il ven, 2002-08-16 alle 11:05, York Ye ha scritto:
> Dear sirs,
>
> I using the last freeds 0.60pre2+ and connect from Redhat 6.1 ( PHP
> 4.03-dev ) to SQL SERVER 2000 on a Win2000. the BIT field return "0?@?/"
> or "1?@Ùö/"...
>
> PHP field info dump:
> name: Deleted
> column_source: Deleted
> max_length: 1
> numeric: 0
>
> this means field length is 1 and it's a non-numeric fields
>
> is there something need to truncate? because i use Sybase Server with BIT
> field it only return "0" or "1"
>
> B.Regards,
> York
> 2002-08-16 PM, China
>
Fixed in CVS (today, so perhaps snapshot is not updated).
Just in tds_convert_bit return 1 converting to VARCHAR.

freddy77

BIT type return from SQL SERVER 2000 need truncate, York Ye, 08/16/2002
- <Possible follow-up(s)>
- Re: BIT type return from SQL SERVER 2000 need truncate, Frediano Ziglio, 08/16/2002
- Re: BIT type return from SQL SERVER 2000 need truncate, York Ye, 08/16/2002