Page 276 - Trackpad 402_Class-X_Final
P. 276

Data Type               Name                              Description

              Number                 NUMERIC               Maximum precision of -e (+/-)231
              Decimal                DECIMAL               Maximum precision of -e (+/-)231

              Real                   REAL                  2 -1074  to (2-2 )* 2 1023
                                                                      -52
              Float                  FLOAT                 2 -1074  to (2-2 )* 2 1023
                                                                      -52
              Double                 DOUBLE                2 -1074  to (2-2 )* 2 1023
                                                                      -52

        Alphanumeric Types
        It stores a set of numbers, alphabets or other characters. We can use this data type for creating name, address, city,
        customer name, product name, product description, etc.

        The list of available Alphanumeric types is:

                Data Type                 Name                                  Description
                                                            Store up to the max length or number indicated by user. It
          Memo                  LONGVARCHAR
                                                            accepts any UTF 8 Character.
                                                            Store exactly the length specified by user. Pads with tailing
          Text (fix)            CHAR
                                                            spaces for shorter strings. Accepts any UTF 8 Character.

                                                            Store up to the specified  length.  No padding  (Same as
          Text                  VARCHAR
                                                            long var char)
                                                            Store up the specified length. Comparisions are not case
          Text                  VARCHAR_IGNORECASE
                                                            sensitive but stores capitals as you type them.

        Binary Types

        It stores the data in a binary format. It is used to store data for images, audio, video or files of any other format.
        The list of the available binary types is:

              Data Type           Name                                    Description
           Image           LONGVARBINARY        Store any array of bytes (images, sounds, etc.). No validation required.

           Binary (fix)    BINARY               Store any array of bytes No validation required.
           Binary          VARBINARY            Store any array of bytes No validation required.

        Date Time

        It stores data in the form of date or time or both. It can be used to store date of joining, date of birth, time of login,
        time of logout, retirement date, date of admission, etc.

        The list of the available Date time types is:

                        Data Type               Name                          Description
                  Date                   DATE                  Store month, day, and year information
                  Time                   TIME                  Store hour, minute, and second information

                  Date/Time              TIMESTAMP             Store date and time information




          276   Trackpad Information Technology-X
   271   272   273   274   275   276   277   278   279   280   281