Subject Re: [firebird-support] decimal separator
Author Timothy Madden
> Hi Sasha! Thanks for the anwser! I typed just an example on the post
> and I
> forgot the parens! Sorry about that! My question actually was if
> Firebird always
> needs dots as decimal separators. And you already answered it also! So
> no matter
> how it is set in "regional settings / currency" in Windows, FB just
> accept a dot
> as decimal separator. Am I right? -sergio
>

Also look at it this way: Firebird is a DB system that tries to implement
(or comply
with) SQL, known as Structured Query Language. This is a standard language
for writing queries to a DB among most database systems today, and it is SQL
which states that numerics should be written with a period. The formal
syntax
taken from the standard is like this:

<exact numeric literal> ::=
<unsigned integer> [ <period> [ <unsigned integer> ] ]
| <period> <unsigned integer>

<unsigned integer> ::= <digit>...

It doesn't say anything about the user's current decimal separator.
You can find the standard on the net if you want to,
just look for SQL92.

Hope that helps
Timothy Madden


[Non-text portions of this message have been removed]