Hi there,
select 1.5/1.2 from dual
delivers "1" as a result. This behaviour shows up only when doing this query
against an oracle server. We're using a "Oracle Database 10g Release
10.2.0.2.0" server and the 10.2.0.2.0 JDBC driver.
When I do the same query against a MS SQL or mysql I get the correct value
"1,25".
If I change the query to
select to_char(1.5/1.2) from dual I get "1,25" as well on an Oracle.
Similar problem arises when displaying "bigger" ints.
For example:
select 123*456*789 from dual;
delivers "44.253.432"
Since I'm running SQuirreL on a localized German windows version, I had the
idea that it may have something to do with localisation problems.
Has anyone noticed something like that before? This behaviour doesn't show
up on 2.1.
Take care
Andreas
|