From: | Ronald Cabral <ronald(dot)t(dot)cabral(at)gmail(dot)com> |
---|---|
To: | pgsql-odbc(at)postgresql(dot)org |
Subject: | Postgresql driver ODBC for linux |
Date: | 2023-06-12 13:14:41 |
Message-ID: | CAAuBg4Tc=7JGz0Aivfx7Kr_+TSnV6bDGOvy36v2QNOUBTxf0zA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
Hi,
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
From | Date | Subject | |
---|---|---|---|
Next Message | Miloslav Zadrazil | 2023-06-14 10:00:20 | psqlODBC drivers 13.2 flagged to be vulnerable for openssl 1.1.1l vulnerabilities |
Previous Message | Niezel, Benjamin (LDBV) | 2023-06-05 08:46:22 | PostgreSQL ODBC driver for PostgreSQL Version 15? |