Precision and localization
A Java SQL client for any JDBC compliant database
Brought to you by:
colbell,
gerdwagner
With the option "Use locale dependent format: 3,14159"
in Global Preferences -> Data type controls -> FLOAT, REAL, DOUBLE, NUMERIC....
a result of
11,1234567890
gets rounded in the content view to a fixed precision of 5 (after decimal point) :
11,12345
With the option "Use default format: 3.14159" i get the real value.
I´m using Squirrel V 3.2.1 and the JTOpen 7.3 JDBC Driver for DB2 Access on
an i5.
sm
Hi,
this is the expected behavior of squirrel.
There is a feature request 3129413 about making the decimal digits for the locale depending format configurable. (See Global Preferences --> 'Data Type Controls')
The feature request is implemented - please try the latest Snapshot.
Stefan