Received: from garbo.DK.net (garbo.DK.net [193.88.44.23]) by hub.org (8.8.8/8.7.5) with ESMTP id FAA02774 for ; Wed, 2 Sep 1998 05:30:25 -0400 (EDT) From: leif@danmos.dk Received: (from uucp@localhost) by garbo.DK.net (8.8.8/8.8.8) id LAA16590 for postgreSQL.org!pgsql-interfaces; Wed, 2 Sep 1998 11:30:21 +0200 (MET DST) >Received: from danmos.dk by danmos with smtp (Smail3.1.28.1 #64) id m0zE9EN-000G4UC; Wed, 2 Sep 98 11:29 MET DST Message-Id: Date: Wed, 2 Sep 98 11:30 WDT To: pgsql-interfaces@postgreSQL.org Subject: Postgres ODBC and SQL_BIT Content-Type: text Hi all, Excuse me for a newbie question. I am trying to make a PostgreSQL database that must be compatible with an existing M$Access database. I have some trouble figuring out what postgres type to use for SQL_BIT. I believe the Access type is called Yes/No (and is used for checkboxes.) I am also using this in a C/C++ program using ODBC. My C/C++ program correctly connects to an Access database with these fields, and I have tried both 'bool' and 'char' as types in the Postgres database, but none of them works. Is there a standard type for this or do I have to make my own (and if so, how?) ? Thanks in advance, ___________________________________________________________________________ / _/ _/_/ / Leif Jensen (leif@danmos.dk) _/ _/ _/ / _/ _/_/ _/_/_/ / _/ _/ _/ _/ _/ / Linux 2.0.33, gcc 2.7.2, wxWin 1.68c _/ _/ _/_/ _/ _/ / _/ _/ _/ _/ _/ / _/_/_/_/ _/_/ _/_/ _/ / (and Windows 95 :-( ___________________________________________________________________________