Re: [Squirrel-sql-users] Strange conversions when doing calculations with Oracle
A Java SQL client for any JDBC compliant database
Brought to you by:
colbell,
gerdwagner
From: Robert M. <rob...@gm...> - 2007-01-15 14:46:24
|
On 1/15/07, CptBlaubaer <cpt...@gm...> wrote: > 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. > This is an effect which I would attribute to using 'Use local-dependent format" as opposed to "Use default format" in Global Preferences -> Data Type Controls -> "Float, Real, Double..." section. Try changing this setting to "Use default format" and see if that fixes it. Rob |