Solved

Schema data type for Numeric(10,2)

3 replies
1849 views
Translate All

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

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

D

DebTrAccepted solution

Level 6

Hi @accuser19 ,

The data type in schema shall be double.

Cheers,

Deb

D

DebTrAccepted solution

Level 6

Hi @accuser19 ,

The data type in schema shall be double.

Cheers,

Deb

Translate

A

ACCUser19Author

Thanks @debtr !

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?

Translate

J

juancarlosrodrigueza

Yes, you should use Double,

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

Translate

Sign up

Login with SSO

Login to the community

Login with SSO