Subject Re: [ib-support] to change the decimal separator
Author Phil Shrimpton
On Tuesday 10 December 2002 13:10, you wrote:


> I am getting an ASCII-File containing SQL Statments Like Insert into
> Artikel (ARTno,Price) Values ('12345','123,22')
> The Result is, that this Article now has Price of 12322 instead of 123.22.
> The Systems I work with runs in Germany and the OS uses the ',' as the
> decimal separator.
> Is there a possability to change the separator Character? I don't want to
> program a Stringconversion for the hole Insertscript.

Firebird, like most other RDBMSs, is not 'locale aware' when it comes to
string conversions. It accepts 'strings' in a few formats specified in the
SQL 'spec', but unless it has changed recently numeric values with a comma as
a separator is not in the spec.

So you input file is incorrect. You are going to have to either get whatever
is producing this file to produce output conforming to the spec, or write
something to do the conversion yourself.


Linux 2.4.4-4GB
12:14pm up 6 days, 18:40, 1 user, load average: 0.17, 0.04, 0.01