Skip site navigation (1) Skip section navigation (2)

Re: SQL_BIT and bit question

From: "Joost Kraaijeveld" <J(dot)Kraaijeveld(at)Askesis(dot)nl>
To: <lothar(dot)behrens(at)lollisoft(dot)de>, <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: SQL_BIT and bit question
Date: 2005-03-11 11:43:29
Message-ID: A3D1526C98B7C1409A687E0943EAC41048A204@obelix.askesis.nl (view raw or flat)
Thread:
Lists: pgsql-odbc
Hi Lothar,

pgsql-odbc-owner(at)postgresql(dot)org schreef:
> Hi,
> 
> I am trying to use a column with type bit and I get a type of
> SQL_CHAR if I call SQLDescribeCol. Is this correct ?
> 
> If I call it for a type of int or integer, I get back SQL_INTEGER.
> 
> How and what datatypes can I use to have similar semantics to bit ?
What happens if you uncheck the "Bools as char" in the "Data options" section of page 1 of the datasources settings (I cannot check what it does because I have no database with a SQL_BIT column)?


Groeten,

Joost Kraaijeveld
Askesis B.V.
Molukkenstraat 14
6524NB Nijmegen
tel: 024-3888063 / 06-51855277
fax: 024-3608416
e-mail: J(dot)Kraaijeveld(at)Askesis(dot)nl
web: www.askesis.nl

pgsql-odbc by date

Next:From: John E. VincentDate: 2005-03-13 02:57:32
Subject: undefined symbol: ucs2_to_utf8
Previous:From: lothar.behrensDate: 2005-03-11 11:25:17
Subject: SQL_BIT and bit question

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group