Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 102 - CoreGPT(Podar)_Flipbook_C8
P. 102

    BigInt <BIGINT>        Similar to Integer type, but with a larger range. Default length: 19 digits.
                           Float <FLOAT>          Stores whole numbers and floating-point values (numbers with

                                                  decimals). Default field length: more than 17 digits.
                           Real <REAL>            Similar to Float type, but uses a different method of storing data.
                                                  Can define up to 17 decimal places.

                           Double <DOUBLE>        Similar to Float type but can handle double the amount of data.
                                                  Provides more precision.

                      2.   Fractional Value Field Types: Used to store numbers with fractional components. Here are the
                         types in this category:

                           Number                  Accepts both whole numbers and numbers with decimals. Can also
                           <NUMERIC>               handle fractions.

                           Decimal <DECIMAL> Specifically used for handling numbers with decimal points,
                                                   ensuring precision in fractional values.

                      Character or String types

                      The text you enter can be stored as either individual characters or a string. These characters or
                      strings are stored in the Text field type. Below are some examples of character or string field
                      types.
                                   Field Type                                       Description

                        Text                               This field type is used for sorting strings, with a default
                                                           length of 50 characters.

                        Text (fixed)                       Similar to Text, but with a fixed length. Blank spaces are
                                                           stored differently in the database for compatibility with
                                                           other applications.
                        Text <VARCHAR_IGNORECASE> This field type ignores case sensitivity and has the same
                                                           length as Text.

                        Memo                               This field type stores large amounts of information, with a
                                                           capacity of up to 2GB.

                      Date and Time Types

                      These are used to store date, time or a combination of both. Below are the date and time field
                      types:
                                   Field Type                                      Description

                        Date <DATE>                        Stores the date (month, day and year).
                        Time <TIME>                        Stores hours, minutes and seconds.

                        Date/Time <TIMESTAMP>              Stores a combination of date and time.

                    100     Premium Edition-VIII

| 97 98 99 100 101 102 103 104 105 106 107 |