public inbox for [email protected]  

help / color / mirror / Atom feed

From: Mauro Gatti <[email protected]>
To: [email protected] <[email protected]>
Subject: ODBC problem with decimal separator
Date: Tue, 7 Nov 2023 16:29:19 +0000
Message-ID: <SY4P282MB4100D636EAD9190147DE26D69BA9A@SY4P282MB4100.AUSP282.PROD.OUTLOOK.COM> (raw)
References: <6ff024fb-be42-47c0-9775-167138e0aafe.cef1fce4-6213-4fe1-bb7b-12047562feeb.04c0497f-f2ad-4295-a9f9-d2efa170767b@emailsignatures365.codetwo.com>
	<6ff024fb-be42-47c0-9775-167138e0aafe.6a78f935-0a1b-4243-9298-6040f93ff6ac.c3b2a680-cf60-41fd-bf35-606ad994d6d7@emailsignatures365.codetwo.com>

Hello,

we are upgrading psqlODBC from version 9 to 15 following the upgrade of the postgres database from version 11 to 15.

The application using psqlODBC is an old legacy application written in .NET Framework and we are facing a problem with the decimal separator.

The application is expecting the separator to be . (dot) and everything is working well, even if the OS locale have , (comma) as separator. The application then needs to open a browser to visualize a PDF file and from that moment on every numeric value returned from the ODBC driver will have comma as decimal separator which is misinterpreted from the application, showing mangled results.

My guess is that the Adobe library used to open the PDF is calling setlocale() to set the decimal separator equal to the OS locale (comma) and this is in turn propagated to the ODBC driver. Before the invocation, the decimal separator is undefined and set to the default locale (dot).

Does anyone know if there's a way to instruct the driver to not apply the locale setting or have experienced something similar?

Regards,




Mauro Gatti

.NET Developer




[https://i.imgur.com/5wrpArH.png]




+39 0 226950535


[https://i.imgur.com/yPFaGzr.png]


        [email protected] <mailto:[email protected]>
[https://i.imgur.com/kBUNJAE.png]


        www.esseitalia.it<https://www.esseitalia.it/en/home-2/;




[https://i.imgur.com/Bfr2vBy.png] <https://www.esseitalia.it/en/home-2/;        [https://i.imgur.com/OZ1IEP1.png]  <https://pentanasolutions.com/general/view/our-values;

        [https://i.imgur.com/zbbA2rr.png]  <https://www.youtube.com/channel/UC9undLWe6RcLflxHW-rAFWA;

        [https://i.imgur.com/jT6psLE.png]  <https://www.linkedin.com/company/pentana-solutions/;


<https://www.pentanasolutions.com/contact/>Contact Us<https://www.esseitalia.it/en/contatti-eng/;






Sede legale: Viale Andrea Doria, 7 - 20124 Milano (MI) - Italy

Sede Operativa: Via Giovanni Antonio Amadeo 59 - 20134 Milano - Italy

P.I. Milano, 09051640150 - C.C.I.A.A. 1266371

C.S. EUR 101.000,00 int. versato

Pentana Solutions accepts no liability for the content of this email, or for the consequences of any actions taken on the basis of the information provided, unless that information is subsequently confirmed in  writing. If you are not the intended recipient, you are notified that disclosing, copying, distributing or taking any action in reliance on the contents of this information is strictly prohibited. Esseitalia is a Pentana Solutions company.

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: ODBC problem with decimal separator
  In-Reply-To: <SY4P282MB4100D636EAD9190147DE26D69BA9A@SY4P282MB4100.AUSP282.PROD.OUTLOOK.COM>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox