Postgres Pro
Downloads
Home   >   mailing lists

Re: Boolean - Mailing list pgsql-odbc

From Jack C. Wei
Subject Re: Boolean
Date
Msg-id CAK_oiDasZGbWtdq=dRT1gt3xwYNL+2eP+xBT7HPu8Xrk5OA+pA@mail.gmail.com
Whole thread Raw
In response to Boolean  ("Ian" <ian@ces-ltd.co.uk>)
Responses RE: Boolean
List pgsql-odbc
Tree view
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@ces-ltd.co.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/

                                  ceslogo2_small                                                              CroftBusinessPark small

 

 

 

Attachment

pgsql-odbc by date:

Previous
From: "Ian"
Date:
Subject: Boolean
Next
From: "Ian"
Date:
Subject: RE: Boolean