Postgres Pro
Downloads
Home   >   mailing lists

Re: NUMERIC type makes trouble in MS Access - Mailing list pgsql-odbc

From Jan Wieck
Subject Re: NUMERIC type makes trouble in MS Access
Date
Msg-id CAGBW59dLVsj+wO9AGqtQ7EUSnNO-tXuAhh==G+muhLLPwO34Gg@mail.gmail.com
Whole thread Raw
In response to Re: NUMERIC type makes trouble in MS Access  ("Tobias Wendorff" <tobias.wendorff@tu-dortmund.de>)
Responses Re: NUMERIC type makes trouble in MS Access  ("Tobias Wendorff" <tobias.wendorff@tu-dortmund.de>)
List pgsql-odbc
Tree view
Anything that is exact precision in the database should never be handled as "double" in any driver. That is a serious bug and a possible violation of accounting laws in many countries. 

That is assuming "double" in this case means "double precision floating point" as in C's double type.


Best Regards,
Jan


On Sat, May 26, 2018 at 10:58 PM, Tobias Wendorff <tobias.wendorff@tu-dortmund.de> wrote:
Some additional information about supported functions and mappings:

https://www.devart.com/odbc/postgresql/docs/supported_data_types.htm
https://www.devart.com/odbc/postgresql/docs/supported_odbc_api_functions.htm

Does PGSQL-ODBC map NUMERIC the same way (to SQL_NUMERIC)?





--
Jan Wieck
Senior Postgres Architect

pgsql-odbc by date:

Previous
From: "Tobias Wendorff"
Date:
Subject: Re: NUMERIC type makes trouble in MS Access
Next
From: "Tobias Wendorff"
Date:
Subject: Re: NUMERIC type makes trouble in MS Access