Data Type

Memory Requirements of a Column Value in Bytes for This Data Type

CHAR(n); VARCHAR(n); key columns

n+1

CHAR(n); no key column; n<=30

n+1

CHAR(n); no key column; 30<n<=254

n+2

CHAR(n); no key column; 254<n

n+3

VARCHAR(n); no key column; n<=254

n+2

VARCHAR(n); no key column; 254<n

n+3

LONG

9

FIXED(p,s)

(p+1) DIV 2 + 2

FLOAT(p)

(p+1) DIV 2 + 2

BOOLEAN

2

DATE

9

TIME

9

TIMESTAMP

21