Postgres Pro
Downloads
Home   >   mailing lists

Thread: Postgres ODBC and SQL_BIT

Postgres ODBC and SQL_BIT

From
leif@danmos.dk
Date:
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 :-(
___________________________________________________________________________

Re: [INTERFACES] Postgres ODBC and SQL_BIT

From
David Hartwig
Date:

leif@danmos.dk wrote:

>   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?) ?

MS Access will not take any ODBC SQL data type and translate it into a check box.
Other tool may do this but not MS Access.   Access only supports check boxes 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.

If you are not using the psqlodbc driver, you are on your own.

Re: [INTERFACES] Postgres ODBC and SQL_BIT

From
"Olaf Mittelstaedt"
Date:
> MS Access will not take any ODBC SQL data type and translate it into a check box.
> Other tool may do this but not MS Access.   Access only supports check boxes 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=false, -1=true), 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ûk, ash nazg gimbatul,
  ash nazg thrakatulûk agh burzum-ishi krimpatul.