MIME-Version: 1.0
From: Karl Aschbacher <krlschbchr@gmail.com>
Date: Mon, 11 Mar 2024 10:21:15 +0100
Message-ID: 
 <CAADAuhBevN0+8fzUpg7j9R6H+dvis0E0nYg2MzPQooEkDyfx_g@mail.gmail.com>
Subject: Value changed from Integer to Double
To: pgsql-odbc@postgresql.org
Content-Type: multipart/alternative; boundary="000000000000e5aefc06135f1051"
Archived-At: 
 <https://www.postgresql.org/message-id/CAADAuhBevN0%2B8fzUpg7j9R6H%2Bdvis0E0nYg2MzPQooEkDyfx_g%40mail.gmail.com>
Precedence: bulk

--000000000000e5aefc06135f1051
Content-Type: text/plain; charset="UTF-8"

Dear all,

we are facing a problem that is maybe related to the postgres-odbc driver.
We use Oracle Analytics Server via ODBC to talk to a postgres Database (V15)
It appears that integers with more than 10 digits get converted to doubles
when the statment is being sent to the database.
So for example: "where id =  32857641330" will be converted to "where did =
3285764133.0 "

So my question is - does the driver play any role when preparing the
statement?
(Like providing the PG Type ?)
In case it does, would anyone have a suggestion where to look for the
potential issue?

many thanks
best regards
Karl

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

<div dir=3D"ltr">Dear all,<div><br></div><div>we are facing a problem that =
is maybe related to the postgres-odbc driver.</div><div>We use Oracle Analy=
tics Server via ODBC to talk to a postgres Database (V15)</div><div>It appe=
ars that integers with more than 10 digits get converted to doubles when th=
e statment is being sent to the database.</div><div>So for example: &quot;w=
here id =3D=C2=A0 32857641330&quot; will be converted to &quot;where did =
=3D 3285764133.0 &quot;</div><div><br></div><div>So my question is - does t=
he driver play any role when preparing the statement?</div><div>(Like provi=
ding the PG Type ?)</div><div>In case it does, would anyone have a suggesti=
on where to look for the potential issue?</div><div><br></div><div>many tha=
nks</div><div>best regards</div><div>Karl</div></div>

--000000000000e5aefc06135f1051--