Unidac 8.1. with Postgres12 Latin9/Iso885915 database

[PeterLorenz]

Dear all,

seems like Unidac is running into encoding problems when connection to an Postgres12 database that is using encoding like that:

CREATE DATABASE test
WITH
OWNER = ortest_mfp
ENCODING = 'LATIN9'
LC_COLLATE = 'en_US.iso885915'
LC_CTYPE = 'en_US.iso885915'
TABLESPACE = pg_default
CONNECTION LIMIT = -1;

CREATE TABLE TEST (
FM_ID BIGINT,
FM_NAME VARCHAR(50),
FM_DESC VARCHAR(50),
);

Insert some Data with german "ä ü ö" and you will receive something like À ÃŒ ö on select.
Seems like data is messed up on insert cause pgadmin even shows À Ì ö .

Any suggestion?

regards
Peter

[oleg0k]

To solve the issue, please try to set the value of the 'UseUnicode' option to True.
Example:

Code: Select all

UniConnection.SpecificOptions.Values['UseUnicode']:='True';