RE: Boolean

Hi All

Thanks for your help.

That worked great.

Now I have the same sort of problem with PostgreSQL Text types not filling MSSQL MEMO fields.

I’ve looked in the DSN definition but I didn’t see anything obvious.

Any ideas please?

Regards

Ian

From: Jack C. Wei [mailto:jackcwei+pgsql(at)gmail(dot)com]
Sent: 27 July 2020 16:28
To: ian(at)ces-ltd(dot)co(dot)uk
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: 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 <mailto: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 <http://Ces-ltd.co.uk> https://ces-ltd.co.uk/the-croft-business-park/