[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 210
  • Last Modified:

Interbase and Regional and language options problem

Hello
We have an application written in Delphi that writes data into an Interbase database.
If in the Regional and language options I set English (US) there are no problems.
If I set it to Dutch (Nederlands), or other european option where the decimal separator is comma instead of the dot the data appears erroneous in the Interbase database. For example 47,83 becomes 4783 as if the separator is lost.

We have verified and the application, which copies a value from a table into another table, transmits the right value.
Is anyone aware with any Interbase problem or setting related to the decimal separator that could help us solve this?
Thank you
hmstechsupport
0
hmstechsupport
Asked:
hmstechsupport
  • 3
  • 2
1 Solution
 
NickUpsonCommented:
interbase has no knowledge of the language settings so I can't see how what you describe could happen, how did you verify?

however you could avoid it by using "insert into tablea (col1) select col2 from tableb" so the application doesn't retrieve the value it stays within the database. NB syntax needs checking as I don't have a system handy to check it
0
 
NickUpsonCommented:
possible solution supplied and questions asked for further detail, I would expect "forced accept" rather than delete
0
 
hmstechsupportAuthor Commented:
Altough the solution provided did not resolve the issue, it did propel us in the right direction
0
 
NickUpsonCommented:
so what was the issue/solution?
0
 
hmstechsupportAuthor Commented:
The SQL that we were using was using a bad TYPE conversion that caused the comma (,) to be lost when the regional settings were not US.
0

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now