[Libreoffice-bugs] [Bug 138409] FIREBIRD: decimal fields in table are falsifying their default values

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=138409

--- Comment #4 from Robert Großkopf <robert at familiegrosskopf.de> ---
(In reply to Julien Nabet from comment #3)> 
> 
> 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.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20201206/7d915f6f/attachment.htm>