Subject | Re: [firebird-support] decimal separator |
---|---|
Author | Timothy Madden |
Post date | 2008-08-27T07:27:25Z |
> Hi Sasha! Thanks for the anwser! I typed just an example on the postAlso look at it this way: Firebird is a DB system that tries to implement
> 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
>
(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]