Subject | Re: [firebird-support] Re: [ib-support] to change the decimal separator |
---|---|
Author | Alexandre Benson Smith |
Post date | 2006-08-30T04:53:53Z |
aandea_launch wrote:
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)
????
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br
> Hello All,I forgot to mention
>
> 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?
>
>
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