We show some tables with all the data types that exist in SQL.
SQL data types are classified into 13 primary data types and several recognized valid synonyms for those data types. The primary data types are: Data Type Length Description BINARY 1 byte For queries on attached table of database products that define a Binary data type. BIT1 byteValues Yes/No or True/False BYTE1 byteAn integer value between 0 and 255. COUNTER4 bytesAn automatically incremented number (Long type) CURRENCY8 bytesA scalable integer between 922.337.203.685.477.5808 and 922.337.203.685.477.5807. DATETIME8 bytesA date or time value between the years 100 and 9999. SINGLE4 bytesA single-precision floating-point value with a range of -3.402823*1038 to -1.401298*10-45 for negative values, 1.401298*10-45 to 3.402823* 1038 for positive values, and 0. DOUBLE8 bytesA double-precision floating-point value with a range of -1.79769313486232*10308 to -4.94065645841247*10-324 for negative values, 4.94065645841247*10-324 to 1.79769313483082 for positive values, and 0. SHORT2 bytesA short integer between -32,768 and 32,767. LONG4 bytesA long integer between -2,147,483,648 and 2,147,483,647. LONGTEXT1 byte per characterZero to a maximum of 1.2 gigabytes. LONGBINARYAs neededFrom zero 1 gigabyte. Used for OLE objects. TEXT1 byte per character Zero to 255 characters.
The following table lists the synonyms of the defined data types: Data Type Synonyms BINARYVARBINARY BITBOOLEAN
LOGICAL
LOGICAL1
YESNO BYTEINTEGER1 COUNTERAUTOINCREMENT CURRENCYMONEY DATETIMEDATE
TIME
TIMESTAMP SINGLEFLOAT4
IEEESINGLE
ROYAL DOUBLEFLOAT
FLOAT8
IEEEDOUBLE
NUMBER
NUMERIC SHORTINTEGER2
SMALLINT LONGINT
INTEGER
INTEGER4 LONGBINARYGENERAL
OLEOBJECT LONGTEXTLONGCHAR
MEMO
NOTE TEXT ALPHANUMERIC
CHAR – CHARACTER
STRING – VARCHAR VARIANT (Not Supported) VALUE
Facebook Comments
Disqus