view decimal(,) decimal(.)
| User, date | Message |
|---|---|
|
Written by paulowelson
1 year ago Category: General 3 posts since Wed, 08 Jun 11 |
to enter a value of an attribute with the decimal type HeidiSQL presents the 10th comma (,) instead of dot (.), as saved in the bank. |
|
Written by ansgar
1 year ago 3950 posts since Fri, 07 Apr 06 |
Very normal. HeidiSQL displays decimals with local formatting. |
|
Written by lemon_juice
1 year ago 94 posts since Tue, 29 Jun 10 |
I find it would be a useful option to be able to turn off local formatting. When programming in any language only the dot is allowed as a decimal point, which makes copying and pasting a bit more tedious because each time I have to convert the comma to a dot. Even SQL itself doesn't accept commas. In most cases I need dots. |
|
Please login to leave a reply, or register at first. |