Schema data type for Numeric(10,2)

[ACCUser19]

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

[Deb_Tripathy · Accepted solution]

Hi @ACCUser19 ,

The data type in schema shall be double.

Cheers,

Deb

[ACCUser19]

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? 

[juancarlosrodrigueza]

Yes, you should use Double,

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