Menu

#3 insertion of a float in a forign lang database

open
Dan
SQL Syntax (1)
7
2004-09-12
2004-09-12
Dan
No

CUT AND PAISTE FROM SUPPORT EMAIL:

We have a problem with float numbers.
The insertion of float numbers using ORM in the
database seems to be related to the value of "regional
options" : decimal character" of the computer.
If we define "." symbol as the decimal character :
everything is OK
If we use "," symbol as the decimal character : the
generated request used by ORM looks like (SELECT *
from TABLE1 WHERE field1 = 0,1) and the coma
generates an error in SQL.
As we are French, it is impossible to ask every user to
modify this environment parameters.

Is there a solution?
Thanks in advance.

Regards,
Name withheld.

Discussion


Log in to post a comment.

Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.