I am setting up Heterogenous services to connect Oracle to Postgresql.
how can i check if my postgres ODBC driver can support Unicode.
the connection is failing if HS_LANGUAGE is UTF8 but OK using AMERICAN_AMERICA.WE8ISO8859P9
-bash-4.2$ rpm -qa | grep -i odbc
unixODBC-2.3.1-14.0.1.el7.x86_64
postgresql-odbc-09.03.0100-2.el7.x86_64
-bash-4.2$ more /home/oracle/.odbc.ini
[ODBC Data Sources]
PG = PostgreSQL
[PG]
Description = Postgres
Driver = PostgreSQL
ServerName = glsdvlpgdb132
Username = wmscoe_dashboard
Password = n4SX2ey9qWRa
Port = 5432
Database=gpwcd01d
ConnSettings=SET CLIENT_ENCODING TO 'UTF8'
[Default]
Driver = /usr/lib64/liboplodbcS.so.2
-bash-4.2$ more /etc/odbcinst.ini
# Example driver definitions
# Driver from the postgresql-odbc package
# Setup from the unixODBC package
[PostgreSQL]
Description = ODBC for PostgreSQL
Driver = /usr/lib/psqlodbcw.so
Setup = /usr/lib/libodbcpsqlS.so
Driver64 = /usr/lib64/psqlodbcw.so
Setup64 = /usr/lib64/libodbcpsqlS.so
FileUsage = 1
# Driver from the mysql-connector-odbc package
# Setup from the unixODBC package
[MySQL]
Description = ODBC for MySQL
Driver = /usr/lib/libmyodbc5.so
Setup = /usr/lib/libodbcmyS.so
Driver64 = /usr/lib64/libmyodbc5.so
Setup64 = /usr/lib64/libodbcmyS.so
FileUsage = 1