Schema data type for Numeric(10,2) | Community
Skip to main content
A
ACCUser19
October 1, 2021
Solved

Schema data type for Numeric(10,2)

  • October 1, 2021
  • 1 reply
  • 1799 views

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.
Best answer by DebTr

Hi @accuser19 ,

The data type in schema shall be double.

 

Cheers,

Deb

1 reply

D
DebTrAccepted solution
Level 6
October 1, 2021

Hi @accuser19 ,

The data type in schema shall be double.

 

Cheers,

Deb

    A
    ACCUser19Author
    October 1, 2021

    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? 

    J
    juancarlosrodrigueza
    February 11, 2022

    Yes, you should use Double,

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

    Terms & ConditionsAccessibility statement

    Loading footer...