Hi,

I'm using ADO to pull data from a MariaDB database.

Problems arise when my data is in decimal format on the Server side.

E.g.

Server Value
---------

109.00
102.50
10.52


VBA query return
-----------
1.09
10.25
10.52

It seems that the main digits are preserved but the decimal points are not.

Does anyone know what is going wrong?

i can fix it by changing the data type to float.

However as this is financial data, decimal is the recommended data type.

Further more if I use float as the datatype on the server

I still get the wrong values e.g. some other small value is tagged onto the end.


VBA query return
-----------
109.00000212
102.50001263
10.521454561

Can anyone please help shed some light on what is going on?

Thanks!