Issue 18632

Summary: Localization floating point number formats impede inserting into ODBC databases.
Product: Base Reporter: Unknown <non-migrated>
Component: codeAssignee: ocke.janssen
Status: CLOSED DUPLICATE QA Contact: issues@dba <issues>
Severity: Trivial    
Priority: P3 CC: issues
Version: OOo 1.1 RC3   
Target Milestone: ---   
Hardware: PC   
OS: Linux, all   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---

Description Unknown 2003-08-25 14:10:10 UTC 
I create a MyODBC data source and I define a floating point field in the tables.
Then I make a Form with an autopilot. All seems to be right.
But when I introduce data in the float type field OpenOffice.org sends an
incorrect query due to the coma separator of the floats in my localization
format (Spanish).

In one of my tests MySQL receives this:

INSERT INTO `test` ( `floatfield`) VALUES ( 2,39999999999999991e+00)

MySQL interprets two field values: 2 and 39999999999999991e+00, because of the
',' that in Spanish is the correct separator.

This would be correct:

INSERT INTO `test` ( `floatfield`) VALUES ( '2,39999999999999991e+00')
Comment 1 Frank Schönheit 2003-08-26 08:18:42 UTC 
ocke, is this a resurrection of MySQL's locale problem?
Comment 2 ocke.janssen 2003-08-26 08:27:55 UTC 
.

*** This issue has been marked as a duplicate of 6600 ***
Comment 3 hans_werner67 2004-02-02 12:58:25 UTC 
change subcomponent to 'none'
Comment 4 ocke.janssen 2004-02-10 14:38:42 UTC 
close it