Strange conversions when doing calculations with Oracle

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

-------------------------------------------------------------------------
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_______________________________________________
Squirrel-sql-users mailing list
Squirrel-sql-users@xxxxxxxxxxxxxxxxxxxxx
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users