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

*

You may use these HTML tags and attributes: <a href="" title="" rel=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>