SQL for Database Construction and Application Processing - Database Processing: Fundamentals, Design, and Implementation - page 287

String Data Types Description

CHAR
(n[BYTE | CHAR])
VARCHAR2
(n[BYTE | CHAR])

n-byte fixed-length string data (non-Unicode). Range of n is from 1 through
2000 . BYTE and CHAR refer to the semantic usage. See documentation.
n-byte variable-length string data (non-Unicode). Range of n is from 1
through 4000 BYTEs or CHARACTERs. BYTE and CHAR refer to the
semantic usage. See documentation.

NCHAR (n) (n x 2)-byte fixed-length Unicode string data. Up to (n x 3)-bytes for UTF8

encoding. Maximum size is from 2000 bytes.

NVARCHAR2 (n) Variable-length Unicode string data. Up to (n x 3)-bytes for UTF8 encoding.

Maximum size is from 4000 bytes.

LONG Variable-length string data (non-Unicode) with maximum a maximum

2 (31 - 1) bytes (2 GBytes). See documentation.

CLOB Maximum [(4-GByte - 1)x(database block size)] character large object

(non-Unicode). Supports fixed-length and variable length character sets.

NCLOB Maximum [(4-GByte - 1)x(database block size)] Unicode character

large object. Supports fixed-length and variable length character sets.

Other Data Types Description

ROWID See documentation.

UROWID See documentation.

HTTPURIType See documentation.

XMLType Use for storing XML data. See documentation.

SDO_GEOMETRY See documentation.

(c) Common Data Types in MySQL 5.6

NumericData Type Description

BIT (M)
TINYINT
TINYINT UNSIGNED
BOOLEAN
SMALLINT
SMALLINT
UNSIGNED
MEDIUMINT
MEDIUMINT
UNSIGNED
INT or INTEGER
INT UNSIGNED or
INTEGER UNSIGNED
BIGINT
BIGINT UNSIGNED
FLOAT (P)
FLOAT (M, D)

M = 1 to 64.
Range is from -128 to 127.
Range is from 0 to 255.
0 = FALSE; 1 = TRUE.
Range is from -32,768 to 32,767.
Range is from 0 to 65,535.

Range is from -8,388,608 to 8,388,607.
Range is from 0 to 16,777,215.

Range is from -2,147,483,648 to 2,147,483,647.
Range is from 0 to 4,294,967,295.

Range is from -9,223,372,036,854,775,808 to 9,223,372,036,854,775,807.
Range is from 0 to 1,844,674,073,709,551,615.
P = Precision; Range is from 0 to 24.
Small (single-precision) floating-point number:
M = Display width D = Number of significant digits
Normal (double-precision) floating-point number:
M = Display width P = Precision; Range is from 25 to 53.
Fixed-point number:
M = Total number of digits

DOUBLE (M, P)

DEC (M[,D]) or
DECIMAL (M[,D]) or

Figure 7-4
Continued

FIXED (M[,D]) D = Number of decimals.