Re: Boolean

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]
>
>
>
>
>
>
>