Subject Re: [ib-support] to change the decimal separator
Author Martijn Tonies
Hi,

> My Question is: How do I Change it?
> I am getting an ASCII-File containing SQL Statments Like Insert into
Artikel
> (ARTno,Price) Values ('12345','123,22')

Well, this is wrong - you should have gotten a file with '123.22' ...
Are you creating the file yourself? If so, make sure you use valid SQL.

With regards,

Martijn Tonies
InterBase Workbench - the developer tool for InterBase & Firebird
Firebird Workbench - the developer tool for Firebird
Upscene Productions
http://www.upscene.com

"This is an object-oriented system.
If we change anything, the users object."

> 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.
>
> Gregor Ernst
>
>
>
> ""Martijn Tonies"" <m.tonies@...> schrieb im Newsbeitrag
> news:003701c2a02c$7c171d50$0a02a8c0@seal...
> > Hi,
> >
> > Why don't you change it at the client-side?
> >
> > > I am looking for a command to change the decimal separator. I am
getting
> > an
> > > insert string with "," as decimal separotor.
> > > Can I tell IB to accept this as the separator or do I have to convert
> the
> > > source?