A very small integer. The signed range is -128 to 127. The unsigned range is 0 to 255.

A small integer. The signed range is -32768 to 32767. The unsigned range is 0 to 65535.

A medium-size integer. The signed range is -8388608 to 8388607. The unsigned range is 0 to 16777215.

A normal-size integer. The signed range is -2147483648 to 2147483647. The unsigned range is 0 to 4294967295.

A normal-size integer. The signed range is -2147483648 to 2147483647. The unsigned range is 0 to 4294967295.

A large integer. The signed range is -9223372036854775808 to 9223372036854775807. The unsigned range is 0 to 18446744073709551615.

A small (single-precision) floating-point number. Cannot be unsigned. Allowable values are -3.402823466E+38 to -1.175494351E-38, 0, and 1.175494351E-38 to 3.402823466E+38.

A small (single-precision) floating-point number. Cannot be unsigned. Allowable values are -3.402823466E+38 to -1.175494351E-38, 0, and 1.175494351E-38 to 3.402823466E+38.

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.

This is a synonym for DOUBLE.

This is a synonym for DOUBLE.

An unpacked floating-point number. Cannot be unsigned. Behaves like a CHAR column.

This is a synonym for DECIMAL.

A date. The supported range is \a1000-01-01\a to \a9999-12-31\a.

A date and time combination. The supported range is \a1000-01-01 00:00:00\a to \a9999-12-31 23:59:59\a.

A timestamp. The range is \a1970-01-01 00:00:00\a to sometime in the year 2037. The length can be 14 (or missing), 12, 10, 8, 6, 4, or 2 representing YYYYMMDDHHMMSS, ... , YYYYMMDD, ... , YY formats.

A time. The range is \a-838:59:59\a to \a838:59:59\a.

A year in 2- or 4-digit format (default is 4-digit).

A fixed-length string (1 to 255 characters) that is always right-padded with spaces to the specified length when stored. values are sorted and compared in case-insensitive fashion according to the default character set unless the BINARY keyword is given.

A variable-length string (1 to 255 characters). Values are sorted and compared in case-sensitive fashion unless the BINARY keyword is given.

This is a synonym for CHAR(1).

This is a synonym for CHAR(1).

A column maximum length of 255 (2^8 - 1) characters. Values are sorted and compared in case-sensitive fashion.

A column maximum length of 65535 (2^16 - 1) characters. Values are sorted and compared in case-sensitive fashion.

A column maximum length of 16777215 (2^24 - 1) characters. Values are sorted and compared in case-sensitive fashion.

A column maximum length of 4294967295 (2^32 - 1) characters. Values are sorted and compared in case-sensitive fashion.

A column maximum length of 255 (2^8 - 1) characters.

A column maximum length of 65535 (2^16 - 1) characters.

A column maximum length of 16777215 (2^24 - 1) characters.

A column maximum length of 4294967295 (2^32 - 1) characters.

An enumeration. A string object that can have only one value, chosen from the list of values.

A set. A string object that can have zero or more values, each of which must be chosen from the list of values.

Geographic Datatype

Geographic Datatype

Geographic Datatype

Geographic Datatype

Geographic Datatype

Geographic Datatype

Geographic Datatype