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@ces-ltd.co.uk> Sent: Wednesday, July 29, 2020 5:37 AM To: 'Roger De Four' <radfinancialsystems@gmail.com> Cc: pgsql-odbc@postgresql.org Subject: RE: Boolean
Just following up on my Text WideString Memo problem.