You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@empire-db.apache.org by Rainer Döbele <do...@esteam.de> on 2014/09/19 11:24:02 UTC

Decimal Datatype with scale 10 or above

Hello everybody,

 

I have thought about the problem that until now it has not been possible to define decimals which have a scale with more than 9 digits.

 

In order to maintain backward compatibility I have found that the easiest way would be add simply add a new property to DBTableColumn which allows to get and set the decimal scale.

In the database definition this must then be called after the column has been added like this:

 

DBTableColumn SCALE;

SCALE=addColumn("SCALE", DataType.DECIMAL, 12.0, false);

SCALE.setDecimalScale(10);

 

This will then lead to a DDL statement as follows:

 

CREATE TABLE EMPLOYEES (

   …,

   SCALE DECIMAL(12,10)

 

This should not affect any existing code.

 

If you encounter any problems please let me know.

 

Regards

Rainer