Postgres ODBC and SQL_BIT - Mailing list pgsql-interfaces

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 :-(
___________________________________________________________________________