DOUBLE type decimals rounding

[George]

Hello !
I am having a minor problem, I hope it's a bug and not a feature because it's misleading and made me wonder what I was doing wrong with my database structure / data input.

The situation is simple: DBeaver doesn't show more than 10 decimals in the "Data" tab of the table. I am storing doubles with up to 12 decimals, but when I went to check if they store properly I saw only 10 decimals and rounding the remaining 2 (just noting, column type is double(15,12) ). Thankfully, I figured that the doubles are stored properly, but their true value is not shown when you navigate through the data in the database. This means that no problems are caused in the project, I have checked that the data is retrieved by its true value.

So, my question is simple: Is there an option to prevent DBeaver from rounding the decimals and show their original value instead as it is stored in the database ? If yes, could you set this option to default ? I believe people would prefer to see what data is stored instead of a beautiful looking database.

Thank you in advance !

Best regards,
George

[Serge]

Hi,

Preferences->Database->Result Sets->Data Formats.
Select "Numbers" formatting and set "Maximum fraction digits" to some reasonable value (10 is the default).

[George]

Hi Serge,

thanks, much appreciated !