<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><span class="vcard"><a class="email" href="mailto:serval2412@yahoo.fr" title="Julien Nabet <serval2412@yahoo.fr>"> <span class="fn">Julien Nabet</span></a>
</span> changed
<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>
<br>
<table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>What</th>
<th>Removed</th>
<th>Added</th>
</tr>
<tr>
<td style="text-align:right;">CC</td>
<td>
</td>
<td>lionel@mamane.lu
</td>
</tr></table>
<p>
<div>
<b><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#c8">Comment # 8</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 <span class="vcard"><a class="email" href="mailto:serval2412@yahoo.fr" title="Julien Nabet <serval2412@yahoo.fr>"> <span class="fn">Julien Nabet</span></a>
</span></b>
<pre>With the last test file attached (Firebird embedded test file ok (created with
en-US locale), I made this other test:
- change to French locale (so decimal separator is ",")
- open this last file (editing table field shows that it can't display by
default value as I previously indicated)
- create a new table with:
- "Decimal places":2
- "Default value":12,22
- save
As expected, inserting a new row doesn't work, it display "12,00" then save
"0,12" but when editing table field, everything seems ok.
Lionel: I think the only place to change is field edition, for both when
reading and when writing.
I'm quite sure that internally, the decimal separator should/must be stored
with a "." (since most programming languages are in English).
To make decimal separator "," work, we need an extra display treatment layer.
This is done when inserting records in table (the first one displays ","
whereas it's been created with en-US locale) but not when editing a field of a
table.
What do you think?</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>