view decimal(,) decimal(.)

[expired user #5750]'s profile image [expired user #5750] posted 12 years ago in General Permalink
to enter a value of an attribute with the decimal type HeidiSQL presents the 10th comma (,) instead of dot (.), as saved in the bank.
ansgar's profile image ansgar posted 12 years ago Permalink
Very normal. HeidiSQL displays decimals with local formatting.
lemon_juice's profile image lemon_juice posted 12 years ago Permalink
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.