Q15. Discuss the various Number data type formats available in BASE.
Ans. Numeric data types are further categorized into two types, namely, Whole-Number data type and Fractional data type.
Table 1 describes four Whole-Number data types:
Table 1: Whole- Number data types | |
Data Type | Description |
Tiny Integer [TINYINT] | Allows you to store data with s fixed length of three (3) spaces. In other words, you can store data of three-digit numbers. |
Small Integer [SMALLINT] | Allows you to store data with s fixed length of five (5) spaces. In other words, you can store data of five-digit numbers. |
Integer [INT] | Allows you to store data with s fixed length of ten (10) spaces. It includes the auto value feature, which helps you enter a previously set value automatically. |
Big Integer [BIGINT] | Allows you to store data with s fixed length of nineteen (19) spaces. Similar to the Integer [INT] data type, this data type also has the auto value feature. |
The Fractional data type is further categorized into five types, which are described in Table 2:
Table 2: Fractional data types | |
Data Type | Description |
float[FLOAT] | Allows you to store floating point values. A floating point value is one that is given in the decimal format, such as 14.23. The length of Float [FLOAT] filed can accept numbers that are more than seventeen (17) spaces long. |
Real [REAL] | Allows you to handle data similar to the Float [FLOAT] data type. The data stored in this type is also compatible with other database applications. |
Double [DOUBLE] | Allows you to handle data similar to the Float [FLOAT] data type, except that the size of the field is doubled. In other words, the field size id doubled from 17 to 34. The data stored in this also compatible with other database applications. |
Numeric [NUMERIC] | Allows you to handle data in the number format, the decimal format, and fractions. |
Decimals [DECIMAL] | Allows you to handle data that is specified in decimal point. |