Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Database Link ORACLE xe to POSTGRESQL 13, UTF8.

AhmedaldamMay 26 2022

Hi all.
I've created a connection from oracle to postgres.
Here are my configs:
HS_FDS_CONNECT_INFO = PG
HS_FDS_TRACE_LEVEL = 4
HS_FDS_TRACE_FILE_NAME=/tmp/ora_hs_trace.log
HS_FDS_SHAREABLE_NAME = /usr/lib64/psqlodbc.so
#HS_LANGUAGE = AMERICAN_AMERICA.WE8ISO8859P9
HS_NLS_NCHAR = UCS2
HS_LANGUAGE=AMERICAN_AMERICA.AL32UTF8
# ODBC specific environment variables

set ODBCINI=/etc/odbc.ini

etc/odbc.ini Configs:
Description = PG
Driver = /usr/lib64/psqlodbc.so
ServerName = localhost
Username = authenticator
Password = postgresql119
Port = 5432
Database = pg
[Default]
Driver = /usr/lib64/libodbcpsqlS.so
ConnSettings =SET CLIENT_ENCODING to 'UNICODE'

So, i created a db link in oracle and trying to query data from postgresql. the tables in Postgresql contain german Letters like ä, ö, ü etc. which can not correctly be displayed in oracle.
examples 'Verfügbar' 'VerfÃ¼gbar'.

Please help me or give me some advices. Thanks.

Added on May 26 2022

#heterogeneous-connectivity

2 comments

850 views

1 mention