Store numbers 1

[Kai77]

I would like to store something like 100,5 or 100.5 (100 and a half) in a field. So I chose a decimal as datatype for the field. But it removes the , or . and stores it as 1005. I am probably using the wrong datatype, which is the correct one?

 

[vongrunt]

Decimal is OK, with enough precision and scale - in this case at least (4, 1).

------
heisenbug: A bug that disappears or alters its behavior when one attempts to probe or isolate it
schroedinbug: A bug that doesn't appear until someone reads source code and realizes it never should have worked, at which point the program promptly stops working for everybody until fixed.
[ba