Page 1 of 1

DOUBLE type decimals rounding

PostPosted: Fri Mar 25, 2016 9:02 am
by 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,

Re: DOUBLE type decimals rounding

PostPosted: Fri Mar 25, 2016 10:41 am
by Serge

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

Re: DOUBLE type decimals rounding

PostPosted: Wed Mar 30, 2016 11:08 am
by George
Hi Serge,

thanks, much appreciated !