ibobjects - Re: [IBO] what data type is better than another to... (numeric)

Subject	Re: [IBO] what data type is better than another to... (numeric)
Author	Marcin Bury
Post date	2019-10-25T18:02:54Z

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>

Do: 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