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

