Subject Re: [IBO] what data type is better than another to... (numeric)
Author Gustavo Novaes
Post date 2019-10-25T19:06:56Z
Thank you Marcin!


Gustavo Novaes 




Em sex, 25 de out de 2019 às 15:50, 'Marcin Bury' marcin.bury@... [IBObjects] <IBObjects@yahoogroups.com> escreveu:
 

Hi Gustavo

Numeric in all cases.

I use Numeric(15,2) for standard monetary values and Numeric(9,4) for currency exchange rates.
For unit of measurement numeric(9,2) or other precision you need.

HTH
Marcin


------ Wiadomość oryginalna ------
Od: "Gustavo Novaes gutonovaes19@... [IBObjects]" <IBObjects@yahoogroups.com>
Data: 25.10.2019 18:30:22
Temat: [IBO] what data type is better than another to... (numeric)


Are there any tables that indicate DATATYPE FIELD best suited for known situations?
Example:
- monetary value - NUMERIC OR DOUBLE PRECISION?

- units of measurement (inches, meters, centimeters, millimeters) NUMERIC?
- Height
- Width - in meters, where the need is only 2 decimal places.


Gustavo Novaes