not Boolean - TEXT and WideString

Hi Danny

Thank you for responding so quickly.

Yes I have tried Varchar in PG but when I do that, my Delphi software fails for MSSQL users as the Field is expecting Memo not WideString.

There must be a difference in the Field types because if I delete and redefine the Table.Field in Delphi, the type is given automatically by the Delphi IDE.

I could change both PG and MSSQL to VARCHAR but that means restructuring users with large established databases using Text.

Thanks

Ian

From: Danny Severns [mailto:Danny(at)eidl-sw(dot)com]
Sent: 29 July 2020 12:55
To: ian(at)ces-ltd(dot)co(dot)uk; 'Roger De Four' <radfinancialsystems(at)gmail(dot)com>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: RE: Boolean

Have you tried changing your column on the PG table to VARCHAR without a length qualifier to see if that works? I think TEXT in each of the two DBs have different practical max size limits which might account for the incompatibility error. Theoretically, there should be no difference in the data types TEXT between the two DBs, nor between TEXT and VARCHAR without a length qualifier. Perhaps there is a difference in the table metadata for the columns in each table for the different lengths or other attributes, as noted in your screen shot, and that triggers the incompatibility. It might be worth a shot if you haven’t tried it.

From: Ian <ian(at)ces-ltd(dot)co(dot)uk <mailto:ian(at)ces-ltd(dot)co(dot)uk> >
Sent: Wednesday, July 29, 2020 5:37 AM
To: 'Roger De Four' <radfinancialsystems(at)gmail(dot)com <mailto:radfinancialsystems(at)gmail(dot)com> >
Cc: pgsql-odbc(at)postgresql(dot)org <mailto:pgsql-odbc(at)postgresql(dot)org>
Subject: RE: Boolean

Just following up on my Text WideString Memo problem.

Text as LongVarChar does not seem to work.

From: Roger De Four [mailto:radfinancialsystems(at)gmail(dot)com]
Sent: 27 July 2020 19:00
To: ian(at)ces-ltd(dot)co(dot)uk <mailto:ian(at)ces-ltd(dot)co(dot)uk>
Cc: pgsql-odbc(at)postgresql(dot)org <mailto:pgsql-odbc(at)postgresql(dot)org>
Subject: Re: Boolean

Sorry, meant MS ACCESS :: "Did you mean Axxess Memo field ?"

Best Regards

Roger De Four

Database Developer

RAD Financial Systems

Cell #/WhatsApp: +1-(868)-342-8587

Email: radfinancialsystems(at)gmail(dot)com <mailto:radfinancialsystems(at)gmail(dot)com>

On Mon, 27 Jul 2020 at 10:40, 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/