Hello Alexandre ,

This is an excellent point! We can probabbly conclude that using the
dot as a decimal separator is required in any locale for statically
formatted strings as the SQL constructs will break otherwise. This is
all I need to fight back to upper management on this issue.

Thank you again for the "obvious" examples.

Alin Andea

--- In firebird-support@yahoogroups.com, Alexandre Benson Smith
<iblist@...> wrote:

>
> aandea_launch wrote:
> > Hello All,
> >
> > Can we make the Embedded Firebird Engine (v1.5 or v2.0) to be aware
> > of the OS locale for converting strings to decimal numbers?
> >
> >
> I forgot to mention
>
> How could the engine understand this statement using comma as

decimal place

>
> insert into Foo (Value1, Value2) values (1,2,3)
>
> is this
> insert into Foo (Value1, Value2) values (1.2,3)
>
> or
> insert into Foo (Value1, Value2) values (1,2.3)
>
> or a wrong statement that has 2 fields in the list and 3 values ???

like

> this
> insert into Foo (Value1, Value2) values (1.0,2.0,3.0)
>
> ????
>
>
> > Thank you!
> > Alin Andea
> >
> >
>
>
> --
> Alexandre Benson Smith
> Development
> THOR Software e Comercial Ltda
> Santo Andre - Sao Paulo - Brazil
> www.thorsoftware.com.br
>