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
Unidac 8.1. with Postgres12 Latin9/Iso885915 database
-
- Posts: 1
- Joined: Fri 10 Nov 2017 10:27
Re: Unidac 8.1. with Postgres12 Latin9/Iso885915 database
To solve the issue, please try to set the value of the 'UseUnicode' option to True.
Example:
Example:
Code: Select all
UniConnection.SpecificOptions.Values['UseUnicode']:='True';