Data Types in 10.5 ES
Topics on This Page:
Each column in a table has a specified data type that defines what kind of data can be stored in the column.
Data Type |
Class |
Description |
---|---|---|
Integer |
Integer from -128 to 127 when signed, or from 0 to 255 when unsigned. |
|
Integer |
Integer from -32768 to 32767 when signed, or from 0 to 65535 when unsigned. |
|
Integer |
Integer from -8388608 to 8388607 when signed, or from 0 to 16777215 when unsigned. |
|
Integer |
Integer from -2147483648 to 2147483647 when signed, or from 0 to 4294967295 when unsigned. |
|
Integer |
Integer from -9223372036854775808 to 9223372036854775807 when signed, or from 0 to 18446744073709551615 when unsigned. |
|
Fixed Num |
Fixed-point number |
|
Float |
Single-precision floating-point number |
|
Float |
Double-precision floating-point number |
|
String |
Fixed-length string with limit up to 255 bytes |
|
String |
Fixed-length string of specific character set with limit up to 255 bytes |
|
String |
Variable-length string with limit up to 65,535 bytes |
|
String |
Variable-length string of specific character set with limit up to 65,535 bytes |
|
String |
String for variable-length text data up to 255 bytes |
|
String |
String for variable-length text data up to 65,535 bytes |
|
String |
String for variable-length text data up to 16,777,215 bytes |
|
String |
String for variable-length text data up to 4,294,967,295 bytes |
|
String |
A synonym of LONGTEXT with a default |
|
String |
String for variable-length binary data up to 255 bytes |
|
String |
String for variable-length binary data up to 65,535 bytes |
|
String |
String for variable-length binary data up to 16,777,215 bytes |
|
String |
String for variable-length binary data up to 4,294,967,295 bytes |
|
String |
Fixed-length string for binary data with limit up to 255 bytes |
|
String |
Variable-length string for binary data with limit up to 65,535 bytes |
|
Bit |
Bit data |
|
Set |
One or more comma-separated values from a set of up to 64 pre-selected options |
|
Set |
A single value from up to 65,535 pre-selected options |
|
Time |
Hours, minutes, seconds |
|
Date |
Two-digit or four-digit year |
|
Date |
Year, month, day |
|
Date/Time |
Year, month, day, hours, minutes, seconds with dates from 1970 to 2038 |
|
Date/Time |
Year, month, day, hours, minutes, seconds with dates from 1000 to 9999 |
|
Geometry |
WKB Point coordinate data |
|
Geometry |
WKB LineString from WKB Point coordinate data |
|
Geometry |
WKB MultiPoint from WKB Point coordinate data |
|
Geometry |
WKB MultiLineString from WKB LineString data |
|
Geometry |
WKB MultiPolygon from WKB Polygon data |
|
Geometry |
WKB Polygon from WKB LineString data |
|
Geometry |
WKB Geometry Collection |
|
Geometry |
Accepts collection data; and point, line, polygon single or multi |
|
Alias |
This is an alias for |
|
Binary |
Stores an INET6 or mapped INET4 network address as a BINARY(16) internally while translating it into a CHAR(39) to the user. |
|
SQL/PSM |
This declaration is only available inside a stored procedure. |
|
SQL/PSM |
This is special declaration only available inside a stored procedure. |
|
SQL/PSM |
This is special declaration only available inside a stored procedure. |
|
Date |
See YEAR |
|
Fixed Num |
See DECIMAL |
|
Fixed Num |
See DECIMAL |
|
Fixed Num |
See DECIMAL |
|
Float |
See FLOAT |
|
Float |
See DOUBLE |
|
Float |
See DOUBLE |
|
Float |
See DOUBLE |
|
Integer |
See TINYINT |
|
Integer |
See TINYINT |
|
Integer |
See TINYINT |
|
Integer |
See SMALLINT |
|
Integer |
See MEDIUMINT |
|
Integer |
See MEDIUMINT |
|
Integer |
See INT |
|
Integer |
See INT |
|
Integer |
See BIGINT |
|
SQL/PL |
See DECIMAL |
|
SQL/PL |
See DATETIME |
|
SQL/PL |
See VARBINARY |
|
SQL/PL |
See VARCHAR |
|
SQL/PL |
See LONGTEXT |
|
String |
See BINARY |
|
String |
See CHAR |
|
String |
See NATIONAL CHAR |
|
String |
See VARCHAR |
|
String |
See CHAR |
|
String |
See VARCHAR |
|
String |
See NATIONAL VARCHAR |
|
String |
See VARCHAR |
|
String |
See VARCHAR |
|
String |
See NATIONAL VARCHAR |
|
String |
See VARCHAR |
|
String |
See NATIONAL VARCHAR |
|
String |
See NATIONAL VARCHAR |
|
String |
See VARCHAR |
|
String |
See MEDIUMTEXT |
|
String |
See MEDIUMTEXT |
|
String |
See MEDIUMTEXT |
|
String |
See MEDIUMBLOB |
|
String |
See MEDIUMTEXT |
|
String |
See MEDIUMTEXT |