Re: [Squirrel-sql-users] Strange conversions when doing calculations with Oracle

[Robert M. <rob...@gm...>]

On 1/16/07, CptBlaubaer <cpt...@gm...> wrote:
> Hi Rob,
>
> thanks for the fast reply. It really changes the behaviour. What makes me
> think a bit is, that the other databases (mysql, MS SQL) did provide the
> default format although I had setup the locale-dependent format. Do those
> JDBC drivers return other datatypes?

I don't know. When using the locale-dependent format the code is roughly:

      _numberFormat = java.text.NumberFormat.getInstance();
      _numberFormat.setMaximumFractionDigits(5);
      _numberFormat.setMinimumFractionDigits(0);
      return _numberFormat.format(value)

I agree, it's counter-intuitive that it would be different across
database vendors.

> Anyway, thank you for the fast solution of this problem.
Your welcome.

Rob