Subject RE: [firebird-support] decimal separator
Author Sasha Matijasic
> 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
>

Hi, more or less, yes. :)
Look at it this way, comma is already used for separating columns so 100,23 are in fact two values 100 and 23.
It's sql language thing (as far as i know every sql server behaves in that regard the same), and has nothing to do with windows settings...

And again, don't construct sql on the client side when you don't need to, use parameters.

Sasha