Page 219 - IT_V1.0_Class10
P. 219
Numeric Data Type
Numeric data types consist of numbers, which can be either integers or real numbers, and support arithmetic
calculations. For example, quantities like 15, -47.3, 82.56, and -129 are numeric data types.
The table below lists various data types that can store numeric data.
Name Data type Signed Description
Tiny Integer TINYINT No Store integer range between 0 to 255
Small Integer SMALLINT Yes Store integer range between -2 to + 2 -1
15
15
31
31
Integer INTEGER Yes Store integer range between -2 to + 2 -1
BigInt BIGINT Yes Range between -2 to + 2 -1
63
63
Number NUMERIC Yes Unlimited
Decimal DECIMAL Yes Unlimited
Float FLOAT Yes 5×e −324 to 1.79×10 308
Real REAL Yes 5×e −324 to 1.79×10 308
Double DOUBLE Yes 5×e −324 to 1.79×10 308
Date Data Type
This data type is used to indicate dates and time. For example 12/25/2024, 08:45 AM. The date and time can
be stored in various formats. The table below lists various data types that can store date and time data.
Name Description
Date Stores the year, month and day as it is stored in the system.
Time Stores the time of the day as hour, minute and second.
Timestamp Stores date and time information at once.
Binary Types
The Binary data type is used for storing data in binary formats. This data type in a database can be used for
storing photos, music files, etc. The table below lists various data types that can store binary data.
Data Type Name Description
Binary (fix) BINARY Used to store fixed-length binary data. The length must be defined
when creating the column.
Binary VARBINARY Used to store variable-length binary data. This data type allows storage
of binary data where the length can vary, but it usually has an upper limit.
Image LONGVARBINARY Used to store large binary data, typically larger than the usual BINARY
or VARBINARY data types. This data type is suitable for storing large
objects such as files, images, or multimedia content.
Currency Data Type
The Currency data type is used to store monetary values, ensuring accurate representation and calculation
of financial figures. It supports various international currencies, such as the US dollar ($100.50), British pound
(£500.75), and Indian rupee (₹25.50). It also formats numbers according to the conventions of different
countries, including appropriate currency symbols and decimal separators.
Starting with LibreOffice Base 217

