<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_NEW " title="NEW - FIREBIRD: decimal fields in table are falsifying their default values" href="https://bugs.documentfoundation.org/show_bug.cgi?id=138409#c4">Comment # 4</a> on <a class="bz_bug_link bz_status_NEW " title="NEW - FIREBIRD: decimal fields in table are falsifying their default values" href="https://bugs.documentfoundation.org/show_bug.cgi?id=138409">bug 138409</a> from <a class="email" href="mailto:robert@familiegrosskopf.de" title="Robert Großkopf <robert@familiegrosskopf.de>"> Robert Großkopf</a> <pre>(In reply to Julien Nabet from <a href="show_bug.cgi?id=138409#c3">comment #3</a>)> > > It could be interesting to know if it's Firebird only. > I mean, I don't see in the setObjectWithInfo methods of other drivers > (Mysql, Postgresql,...) any specific treatment to deal with separator. Hi Julien, have tested it with internal HSQLDB. Set a default for a decimal field to "3,75" and formatted it for showing the 2 decimal places. When opening the table I see "3,00" instead. And this is the value which will be saved in HSQLDB. If I set 3.75 I have to choose English as language for the decimal separator in the table editor to format it with 2 decimal places. Then I open the table for input data and it will show 3.75. Now I changed this German decimal separator and it works: 3,75. So it is a different behavior, but it would only work right with the point as decimal separator. Tested with LO 7.0.4.1 on OpenSUSE 15.1 64bit rpm Linux.</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>