From: | "Jack C(dot) Wei" <jackcwei+pgsql(at)gmail(dot)com> |
---|---|
To: | ian(at)ces-ltd(dot)co(dot)uk |
Cc: | pgsql-odbc(at)postgresql(dot)org |
Subject: | Re: Boolean |
Date: | 2020-07-27 15:27:49 |
Message-ID: | CAK_oiDasZGbWtdq=dRT1gt3xwYNL+2eP+xBT7HPu8Xrk5OA+pA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
There's a "Bools as Char" option in psqlodbc. Try turning it off. If you're
using DSN, the option is in page 1 of the Options dialog box. If you're
using a connection string, add "BoolsAsChar=0;" to it. See
https://odbc.postgresql.org/docs/config.html
Disclaimer: I've never used this option myself so can't say for sure. I
actually use smallint instead of boolean in my design.
On Mon, Jul 27, 2020 at 7:40 AM Ian <ian(at)ces-ltd(dot)co(dot)uk> wrote:
> Hello
>
>
>
> I am trying to use PostgreSQL as an alternative to MS SQL express.
>
> But when my Delphi table opens, the Boolean field fails as it says that it
> expects Boolean but receives string.
>
>
>
> How can I get Boolean to be a BIT?
>
>
>
> Thank you
>
>
>
> Ian
>
>
>
> Ian Burrows
>
>
>
> 07767 834329
>
> *CES Ltd.*
>
> 11 Alverton Close
>
> YO17 6RR
>
> Ces-ltd.co.uk
>
> https://ces-ltd.co.uk/the-croft-business-park/
>
> [image: ceslogo2_small]
> [image:
> CroftBusinessPark small]
>
>
>
>
>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Ian | 2020-07-27 17:52:02 | RE: Boolean |
Previous Message | Ian | 2020-07-27 12:18:22 | Boolean |