Skip to main content
ACCUser19
October 1, 2021
Beantwortet

Schema data type for Numeric(10,2)

  • October 1, 2021
  • 3 Antworten
  • 1845 Ansichten

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

Dieses Thema wurde für Antworten geschlossen.
Beste Antwort von DebTr

Hi @accuser19 ,

The data type in schema shall be double.

 

Cheers,

Deb

3 Antworten

DebTrAntwort
Level 6
October 1, 2021

Hi @accuser19 ,

The data type in schema shall be double.

 

Cheers,

Deb

    ACCUser19Autor
    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? 

    juancarlosrodrigueza
    February 11, 2022

    Yes, you should use Double,

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

    Allgemeine NutzungsbedingungenAccessibility statement

    Loading footer...