Image
0

Ukuran (Size) Masing-masing Tipe Data pada DB2

TIPE DATA UKURAN (bytes) KETERANGAN
CHAR(n) n n <= 255
VARCHAR(n) n+2
GRAPHIC(n) 2*n
VARGRAPHIC(n) (2*n)+2
BINARY(n) n
VARBINARY(n) n+2
DECIMAL(n) or NUMERIC(n) (n+1)/2 Dibulatkan ke atas jika hasilnya tidak bulat
DECFLOAT(16) 8
DECFLOAT(32) 16
SMALLINT 2
INTEGER 4
BIGINT 8
REAL 8
FLOAT(n) 8 jika 23 <= n <= 53
FLOAT 4
ROWID 19
DATE 4
TIME 3
TIMESTAMP 10
BLOB 6
CLOB 6
DBCLOB 6

*Kolom yang nullable ditambah 1 byte

Leave a Reply

Your email address will not be published. Required fields are marked *

CAPTCHA Image

*