MIME-Version: 1.0
From: Ronald Cabral <ronald.t.cabral@gmail.com>
Date: Mon, 12 Jun 2023 21:14:41 +0800
Message-ID: 
 <CAAuBg4Tc=7JGz0Aivfx7Kr_+TSnV6bDGOvy36v2QNOUBTxf0zA@mail.gmail.com>
Subject: Postgresql driver ODBC for linux
To: pgsql-odbc@postgresql.org
Content-Type: multipart/alternative; boundary="0000000000000d968e05fdee818d"
Archived-At: 
 <https://www.postgresql.org/message-id/CAAuBg4Tc%3D7JGz0Aivfx7Kr_%2BTSnV6bDGOvy36v2QNOUBTxf0zA%40mail.gmail.com>
Precedence: bulk

--0000000000000d968e05fdee818d
Content-Type: text/plain; charset="UTF-8"

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

--0000000000000d968e05fdee818d
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr"><div dir=3D"ltr"><div dir=3D"ltr"><div di=
r=3D"ltr"><div>Hi,</div><div><br></div><div>I am setting up Heterogenous se=
rvices to connect Oracle to Postgresql.</div><div>how can i check if my pos=
tgres ODBC driver can support=C2=A0Unicode.</div><div>the connection is fai=
ling if HS_LANGUAGE is UTF8 but OK using=C2=A0AMERICAN_AMERICA.WE8ISO8859P9=
</div><div><br></div><div><br></div><div><div>-bash-4.2$ rpm -qa | grep -i =
odbc</div><div>unixODBC-2.3.1-14.0.1.el7.x86_64</div><div>postgresql-odbc-0=
9.03.0100-2.el7.x86_64</div></div><div><br></div><div><div>-bash-4.2$ more =
/home/oracle/.odbc.ini</div><div>[ODBC Data Sources]</div><div>PG =3D Postg=
reSQL</div><div><br></div><div>[PG]</div><div>Description =3D Postgres</div=
><div>Driver =3D PostgreSQL</div><div>ServerName =3D glsdvlpgdb132</div><di=
v>Username =3D wmscoe_dashboard</div><div>Password =3D n4SX2ey9qWRa</div><d=
iv>Port =3D 5432</div><div>Database=3Dgpwcd01d</div><div>ConnSettings=3DSET=
 CLIENT_ENCODING TO &#39;UTF8&#39;</div><div>[Default]</div><div>Driver =3D=
 /usr/lib64/liboplodbcS.so.2</div></div><div><br></div><div><br></div><div>=
<div>-bash-4.2$ more /etc/odbcinst.ini</div><div># Example driver definitio=
ns</div><div><br></div><div># Driver from the postgresql-odbc package</div>=
<div># Setup from the unixODBC package</div><div>[PostgreSQL]</div><div>Des=
cription=C2=A0 =C2=A0 =C2=A0=3D ODBC for PostgreSQL</div><div>Driver=C2=A0 =
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =3D /usr/lib/psqlodbcw.so</div><div>Setup=C2=A0=
 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0=3D /usr/lib/libodbcpsqlS.so</div><div>D=
river64=C2=A0 =C2=A0 =C2=A0 =C2=A0 =3D /usr/lib64/psqlodbcw.so</div><div>Se=
tup64=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0=3D /usr/lib64/libodbcpsqlS.so</div>=
<div>FileUsage=C2=A0 =C2=A0 =C2=A0 =C2=A0=3D 1</div><div><br></div><div><br=
></div><div># Driver from the mysql-connector-odbc package</div><div># Setu=
p from the unixODBC package</div><div>[MySQL]</div><div>Description=C2=A0 =
=C2=A0 =C2=A0=3D ODBC for MySQL</div><div>Driver=C2=A0 =C2=A0 =C2=A0 =C2=A0=
 =C2=A0 =3D /usr/lib/libmyodbc5.so</div><div>Setup=C2=A0 =C2=A0 =C2=A0 =C2=
=A0 =C2=A0 =C2=A0=3D /usr/lib/libodbcmyS.so</div><div>Driver64=C2=A0 =C2=A0=
 =C2=A0 =C2=A0 =3D /usr/lib64/libmyodbc5.so</div><div>Setup64=C2=A0 =C2=A0 =
=C2=A0 =C2=A0 =C2=A0=3D /usr/lib64/libodbcmyS.so</div><div>FileUsage=C2=A0 =
=C2=A0 =C2=A0 =C2=A0=3D 1</div></div><div><br></div><div><br></div></div></=
div></div></div></div>

--0000000000000d968e05fdee818d--