Hi,
I have an very strange issue with a software compiled on Delphi 2010 using Unidac v3.70.0.17, this software is (mostly) on maintenance only mode and is being stable for many year.

 

After the system administrator of this customer changed the Oracle client from 11.2 (full) to 21.8 (instant) some values that are saved on Float field, appear to be encoded in a way that only our software can read, saving values like 1.920.000 that is normally represented with a RAW value of C4025D is instead saved with a RAW value of C4025C65

I am clueless of why this can be happening and reverting to the old 11.2 client solve the problem 
we tested this behaviour directly with SQLPlus but also with SQLDBX and DBeaver

here an example, red rows are saved with the new client, green one with the old

The issue is reported by only one of my customers, never had been reported by any other of my customer

Some additional information:
this server is using the Swiss locale and the SA refuse to install the full 21 Oracle client and to change the locale so we are a bit tided up on what we can do to the system.
I tried to update to a more recent version of Unidac (9.0.1) that I use on another software and the issue remain but also the software crash on exit (stuck on memory eating 1 full core), so I hope there is maybe some driver or unidac configuration that I try before doing a fullstack update to the last version of Unidac