Character Strings

CHAR (n: 1-8000)

• Description: Fixed-length, non-Unicode character data.
• The storage size is (n) bytes.
• ISO synonym: character
• Oracle: char[(size)], 1 ≤ size ≤ 2,000 bytes

Unicode Character strings

NCHAR (n: 1-4000)

• Description: Fixed-length Unicode character data.
• The storage size is (2 x n) bytes entered.
• ISO synonym: national char, national character
• Oracle: nchar[(n)], 1 ≤ n ≤ 2,000 characters; nclob, n > 2000

VARCHAR (n: 1-8000 | max: 2^31-1 bytes**)**

• Description: Variable-length, non-Unicode character data.
• The storage size is (n) bytes.
• ISO synonym: character varying, char varying
• Oracle: varchar2(n), or clob (n>4000)

NVARCHAR (n: 1-4000 | max: 2^31-1 bytes**)**

• **Description:**Variable-length Unicode character data.
• The storage size is (2 x n) bytes entered + 2 bytes.
• ISO synonym: national character varying, national char varying
• Oracle: varchar2(n), or clob (n>4000)

TEXT

• Variable-length non-Unicode data in the code page of the server and with a maximum length of 2^31-1 characters.
• ISO synonym: N/A, Oracle: clob

NTEXT

• Description: Variable-length Unicode data with a maximum length of 2^30 – 1.
  • Storage size, in bytes, is two times the number of characters entered.
• ISO synonym: national text, Oracle: nclob

Binary Values

BINARY (n: 1-8000)

• Description: Fixed-length binary data.
• Storage: (n) bytes.
• ISO synonym: N/A, Oracle: raw(1) (n was omitted); raw(n), 1≤n≤2000;blob(n>2000)

VARBINARY (n: 1-8000 | max: 2^31-1 bytes**)**

• Description: Variable-length binary data.
• Storage: The actual length of the data entered + 2 bytes.
• ISO synonym: binary varying
  • Oracle: raw(1)(n was omitted); raw(n), 1≤n≤2000;blob(n>2000)

IMAGE

• Description: Variable-length binary data from 0 through 2^31-1 (2,147,483,647) bytes.
• ISO synonym: N/A, Oracle: blob

Numerics

BIT

• Description: An integer data type that can take a value of 1, 0.
• Storage: SQL server optimizes bit storage by storing every 8 or less bit columns into a 1 byte storage (8 bits).
• ISO synonym: N/A, Oracle: NUMBER(3)

BIGINT

• Range: -2^63 (-9,223,372,036,854,775,808) to 2^63-1 (9,223,372,036,854,775,807)
• Storage: 8 bytes.
• ISO synonym: N/A, Oracle: NUMBER(19)

INT

• Range: -2^31 (-2,147,483,648) to 2^31-1 (2,147,483,647)
• Storage: 4 bytes.
• ISO synonym: N/A, Oracle: NUMBER(10)

SMALLINT

• Range: -2^15 (-32,768) to 2^15-1 (32,767)
• Storage: 2 bytes
• ISO synonym: N/A, Oracle: NUMBER(5)

TINYINT

• Range: 0 to 255
• Storage: 1 byte
• ISO synonym: N/A, Oracle: NUMBER(3)

NUMERIC(p[,s]), DECIMAL(p[,s])

• Description: Numeric data types that have fixed precision and scale.
• Precision is the maximum total number of decimal digits that will be stored, both to the left and to the right of the decimal point.
• Scale is the number of decimal digits that will be stored to the right of the decimal point. It is subtracted from precision to determine the maximum number of digits to the left and right of the decimal point.
• Precision Range: 1 to 38. When maximum precision is used, valid values are from - 10^38 +1 through 10^38 - 1