mysql numeric/decimal fields

Classic Servoy
1

I have a mysql database with several NUMERIC/DECIMAL fields (they are defined as NUMERIC but SHOW CREATE TABLE lists them as DECIMAL) which are currency amounts and have length with two decimal places, such as DECIMAL(5,2).

Curiously, servoy thinks these are of type NUMBER and length “2”.

Is that how it’s supposed to be?

Environment: “Servoy R2 2.0.4 build-277 on Linux using Java 1.4.2_03”

Thanks,
Neale.

2

currently servoy only shows the the number behind the digits.
in the further we will have better support for numeric/decimal fields.