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
   214   215   216   217   218   219   220   221   222   223   224