Re: Strange conversions when doing calculations with Oracle

On 1/15/07, CptBlaubaer <cptblaubaer@xxxxxxxxx> 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

-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys - and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV