DOUBLE type decimals rounding

Note: please leave bug reports and feature requests on

DOUBLE type decimals rounding

Postby George » Fri Mar 25, 2016 9:02 am

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
George
 
Posts: 7
Joined: Fri Feb 19, 2016 3:58 pm

Re: DOUBLE type decimals rounding

Postby Serge » Fri Mar 25, 2016 10:41 am

Hi,

Preferences->Database->Result Sets->Data Formats.
Select "Numbers" formatting and set "Maximum fraction digits" to some reasonable value (10 is the default).
Serge
 
Posts: 1526
Joined: Sat Feb 26, 2011 8:24 pm
Location: SPb

Re: DOUBLE type decimals rounding

Postby George » Wed Mar 30, 2016 11:08 am

Hi Serge,

thanks, much appreciated !
George
 
Posts: 7
Joined: Fri Feb 19, 2016 3:58 pm


Return to Support



Who is online

Users browsing this forum: No registered users and 21 guests