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)

Avatar

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

Avatar

Correct answer by
Community Advisor

Hi @ACCUser19 ,

The data type in schema shall be double.

 

Cheers,

Deb

View solution in original post

3 Replies

Avatar

Correct answer by
Community Advisor

Hi @ACCUser19 ,

The data type in schema shall be double.

 

Cheers,

Deb

Avatar

Level 1

Thanks @Deb_Tripathy !

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? 

Avatar

Level 1

Yes, you should use Double,

There is no way to limit the number of precision digits.