Expand my Community achievements bar.

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.