Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SOLVED

Schema data type for Numeric(10,2)

ACCUser19
Level 1
Level 1

I would like to know which data type should I use (Float, Double, or Long) for a field that would be populated with Numeric(10,1) and another field with Numeric(10,2). Please help.


Thanks

1 Accepted Solution
Deb007
Correct answer by
Level 6
Level 6

Hi @ACCUser19 ,

The data type in schema shall be double.

 

Cheers,

Deb

View solution in original post

2 Replies
Deb007
Correct answer by
Level 6
Level 6

Hi @ACCUser19 ,

The data type in schema shall be double.

 

Cheers,

Deb

View solution in original post

ACCUser19
Level 1
Level 1

Thanks @Deb007 !

So if the field has any number of decimal points, we always use the same double? Is there a way to limit the number of precision points when we set the attribute in schema so that DB size could be optimized?