Like 0

Data Types

Data Type Name	Raw Type	Length (Range)	Precision (Range)	Scale (Range)	Description
NUMERIC DATA TYPES
BIGINT	NUMERIC	X	20	X
BIT	NUMERIC	X	1	X	A very small integer. The signed range is -128 to 127. the unsigned range is 0 to 255. bit - Integer data with either a 1 or 0 value.
DECIMAL	NUMERIC	X	10	0	An unpacked floating-point number. Cannot be unsigned. Behaves like a CHAR column: ``unpacked'' means the number is stored as a string, using one character for each digit of the value. The decimal point and, for negative numbers, the `-' sign, are not counted in M
DOUBLE	NUMERIC	X	X	X	A normal-size (double-precision) floating-point number. Cannot be unsigned. Allowable values are -1.7976931348623157E+308 to -2.2250738585072014E-308, 0, and 2.2250738585072014E-308 to 1.7976931348623157E+308.
FLOAT	NUMERIC	X	X	X	A floating-point number. Cannot be unsigned. precision can be <=24 for a single-precision floating-point number and between 25 and 53 for a double-precision floating-point number
INT	NUMERIC	X	X	X	INT is rep for MEDIUMINT
INTEGER	NUMERIC	X	11	X	Synonym for INT ... INTEGER and LONG
LONG	CHARACTER	X	X	X	Synonym for INT ... INTEGER and LONG
MEDIUMINT	NUMERIC	X	9	X	A medium-size integer. The signed range is -8388608 to 8388607. The unsigned range is 0 to 16777215
NUMERIC	NUMERIC	X	10	0	This is a synonym for DECIMAL
REAL	NUMERIC	X	X	X	These are synonyms for DOUBLE.
SMALLINT	NUMERIC	X	6	X	A small integer. The signed range is -32768 to 32767. The unsigned range is 0 to 65535
TINYINT	NUMERIC	X	4	X
CHARACTER DATA TYPES
CHAR	CHARACTER	25	X	X	A fixed-length string that is always right-padded with spaces to the specified length when stored. The range of M is 1 to 255 characters
TINYTEXT	CHARACTER	X	X	X	A TEXT column with a maximum length of 255 (2^8 - 1) characters
VARCHAR	CHARACTER	25	X	X
DATE & TIME DATA TYPES
DATE	DATE	X	X	X	A date. The supported range is '1000-01-01' to '9999-12-31'
DATETIME	DATETIME	X	X	X	A date and time combination. The supported range is '1000-01-01 00:00:00' to '9999-12-31 23:59:59'
TIME	TIME	X	X	X	A time. The range is '-838:59:59' to '838:59:59'
TIMESTAMP	TIMESTAMP	X	X	X	A timestamp. The range is '1970-01-01 00:00:00' to sometime in the year 2037.
YEAR		X	X	X	The YEAR type is a one-byte type used for representing years. It can be declared as YEAR(2) or YEAR(4) to specify a display width of two or four characters. The default is four characters if no width is given.
BINARY & LARGE OBJECT DATA TYPES
BINARY	BINARY	X	X	X	The BINARY type is similar to the CHAR type, but stores binary byte strings rather than non-binary character strings. M represents the column maximum column length in bytes
BLOB	BLOB	X	X	X	A BLOB column with a maximum length of 65535 (2^16 - 1) characters
ENUM	CHARACTER	X	X	X	An enumeration. A string object that can have only one value, chosen from the list of values 'value1', 'value2', ..., NULL or the special "" error value. An ENUM can have a maximum of 65535 distinct values
LONGBLOB	BLOB	X	X	X	A BLOB column with a maximum length of 4294967295 (2^32 - 1) characters
LONGTEXT	CHARACTER	X	X	X	A TEXT column with a maximum length of 4294967295 (2^32 - 1) characters
MEDIUMBLOB	BLOB	X	X	X	A BLOB column with a maximum length of 16777215 (2^24 - 1) characters
MEDIUMTEXT	CHARACTER	X	X	X	A TEXT column with a maximum length of 16777215 (2^24 - 1) characters
SET	CHARACTER	X	X	X	A set. A string object that can have zero or more values, each of which must be chosen from the list of values 'value1', 'value2', ... A SET can have a maximum of 64 members
TEXT	CHARACTER	X	X	X	A TEXT column with a maximum length of 65535 (2^16 - 1) characters
TINYBLOB	BLOB	X	X	X	A BLOB column with a maximum length of 255 (2^8 - 1) characters
VARBINARY	BINARY	X	X	X	The VARBINARY type is similar to the VARCHAR type, but stores binary byte strings rather than non-binary character strings. M represents the maximum column length in bytes

Comments (0) Attachments (0)

This list is empty.

Search Tips

Aqua Data Studio / nhilam

Data Types

Search Tips

Aqua Data Studio / nhilam

Title

Data Types