Re: Either I broke PostgreSQL or I found an ODBC bug - Mailing list pgsql-odbc

Richard Broersma Jr wrote:
> --- On Mon, 11/5/07, Richard Broersma Jr <rabroersma@yahoo.com> wrote:
>
>> No, I guess I did break Postgres with the inttobool
>> function. :-(
>
> On closer inspection, Crystal reports, using the ODBC provider produces the expected results with using boolean.
 > The problem only occurs in ms-access, so I guess that it is a
MS-Access bug.

Hmm I found the following at http://allenbrowne.com/xbase-05.html .

    Unfortunately, Access 95 onwards do not permit Null values in
    Yes/No fields.

regards,
Hiroshi Inoue