Received: from mailex.rz.fh-ulm.de (Mailex.rz.fh-ulm.de [141.59.42.12]) by hub.org (8.8.8/8.7.5) with ESMTP id BAA03867 for ; Thu, 3 Sep 1998 01:35:22 -0400 (EDT) Received: from gate.va.fh-ulm.de (gate.va.fh-ulm.de [141.59.15.1]) by mailex.rz.fh-ulm.de (8.9.1/8.8.8) with SMTP id HAA30020 for ; Thu, 3 Sep 1998 07:35:20 +0200 Received: by gate.va.fh-ulm.de (8.6.11) id HAA08990; Thu, 3 Sep 1998 07:35:11 +0200 Message-Id: <199809030535.HAA08990@gate.va.fh-ulm.de> Received: from va-sigi.va.fh-ulm.de(141.59.12.12) by gate.va.fh-ulm.de via smap (V1.3) id sma008988; Thu Sep 3 07:35:05 1998 Received: from VA-SIGI/SpoolDir by va-sigi.va.fh-ulm.de (Mercury 1.43); 3 Sep 98 07:35:03 +0200 Received: from SpoolDir by VA-SIGI (Mercury 1.43); 3 Sep 98 07:34:35 +0200 From: "Olaf Mittelstaedt" Organization: Verwaltung FH Ulm To: pgsql-interfaces@postgreSQL.org Date: Thu, 3 Sep 1998 07:34:28 +0100 MIME-Version: 1.0 Content-type: text/plain; charset=ISO-8859-1 Content-transfer-encoding: Quoted-printable Subject: Re: [INTERFACES] Postgres ODBC and SQL_BIT CC: pgsql-interfaces@postgreSQL.org Priority: normal In-reply-to: <35ED7971.F5639931@insightdist.com> > MS Access will not take any ODBC SQL data type and translate it into a c= heck box. > Other tool may do this but not MS Access. Access only supports check b= oxes on > Access databases. > > As for what Access it will do - The psqlodbc driver as options to treat = postgresql > bools as SQL_CHAR (t/f) or or SQL_BIT. MS Access displays SQL_BIT as -1= /0. When migrating a database from native Access to Postgres I replaced Boolean with Integers (0=3Dfalse, -1=3Dtrue), I had no problems to use checkboxes connected with those fields. Regards, Olaf -- Olaf Mittelstaedt - IuK - mittelstaedt@fh-ulm.de Fachhochschule Ulm Prittwitzstr. 10 89075 Ulm Tel.: +49 (0)731-502-8220 Fax: -8270 Ash nazg durbatul=FBk, ash nazg gimbatul, ash nazg thrakatul=FBk agh burzum-ishi krimpatul.