Post subject: Using precision and scale atributes for integers and floats.

Posted: Thu Jan 10, 2008 5:41 am

Newbie

Joined: Thu Jan 10, 2008 5:31 amPosts: 1

hi

I wish to limit my database fields for numbers (ints and floats). Iam currently able to limit my fields if they are Strings but not for numbers.
For eg : when i create a type "Cost Price" which is a float in my hbm file and iam trying to use the schema generator and get the DDL , it is by default creating a type like this Cost_Price number(10,0) . Instead i want this to be something like

Cost_Price number(6,2)

Can i make use of the precision and the scale attributes for plain integers and floats?(I know i can use this with Big_integer and Big_decimal.