????DB2??????????????????????(numeric)?????????(character string)??????????(graphic string)???????????????(binary string)???????????(datetime)???????????? DATALINK ???????????????DATALINK ????????洢???????????????????????á?
???????????????????? SMALLINT??INTEGER??BIGINT??DECIMAL(p??s)??REAL ?? DOUBLE????????????з??????????????????????????????????????λ??????????????????????????????????
????*С?????SMALLINT??С????????????????????????? 5 λ??С??????Χ?? -32??768 ?? 32??767??
????*???????INTEGER ?? INT???????????????????????????? 10 λ??????????Χ?? -2??147??483??648 ?? 2??147??483??647??
????*???????BIGINT??????????????????????????? 19 λ??????????Χ?? -9??223??372??036??854??775??808 ?? 9??223??372??036??854??775??807??
????*С?????DECIMAL(p??s)??DEC(p??s)??NUMERIC(p??s) ?? NUM(p??s)??С????????????????????????????????????С???????????????????-????????(binary-coded decimal??BCD)??????????????洢??С?????λ???????????????(p)??С??λ(s)??С??λ????????С???????λ????????????????????????????????????? 31 λ??С??????Χ?? -10**31+1 ?? 10**31-1??
????*???????????(Single-precision floating-point)??REAL???????????????????? 32 λ???????????????????????? -3.402E+38 ?? -1.175E-37 ??? 1.175E-37 ?? 3.402E+38 ???Χ???
????*??????????(Double-precision floating-point)??DOUBLE??DOUBLE PRECISION ?? FLOAT??????????????????? 64 λ???????????????????????? -1.79769E+308 ?? -2.225E-307 ??? 2.225E-307 ?? 1.79769E+308 ???Χ???
?????????????????С?????????? CHAR(n) ??????????????? VARCHAR(n)??LONG VARCHAR ?? CLOB(n) ??????????????????????????????е????????
????*???????????CHARACTER(n) ?? CHAR(n)??????????????????? 1 ?? 254 ???????????????????????????? 1 ??????
????*?????????VARCHAR(n)??CHARACTER VARYING(n) ?? CHAR VARYING(n)??VARCHAR(n) ????????????????????????? 32??672 ????
????*LONG VARCHAR??LONG VARCHAR ????????????????????????? 32??700 ????
????*?????????????(Character Large Object String)??CLOB(n[K|M|G])??CLOB ????????????????? 2??147??483??647 ????????????? n????? n ????????????????? nK??????????? n*1??024(n ????? 2??097??152)?????????? nM??????????? n*1??048??576(n ????? 2??048)?????????? nG??????????? n*1??073??741??824(n ?????? 2)??CLOB ????洢?????????????(single-byte character set??SBCS)???????????????(??????????(MBCS)?? SBCS)????????????????????????????????????????С?????????????????? GRAPHIC(n) ???????????????????? VARGRAPHIC(n)??LONG VARGRAPHIC ?? DBCLOB(n) ?????????????????????????????????????????????
????*??????????????GRAPHIC(n)?????????????????????? 1 ?? 127 ??????????????????????????????? 1 ???????????
????*????????????VARGRAPHIC(n)??VARGRAPHIC(n) ????????????????????????????? 16??336 ???????????
????*LONG VARGRAPHIC??LONG VARGRAPHIC ????????????????????????????? 16??350 ???????????
????*???????????????????DBCLOB(n[K|M|G])??????????????????????????????????????? 1??073??741??823 ???????????????? n????? n ?????????????? nK??????????? n*1??024(n ????? 1??048??576)?????????? nM??????????? n*1??048??576(n ????? 1??024)?????????? nG??????????? n*1??073??741??824(n ?????? 1)??DBCLOB ????洢????? DBCS(???????????double-byte character set)?????????????????????????????С???????????????? BLOB(n) ?????????????????????????????????????????????????y????????????????????????????????????????????????
????* ??????????BLOB(n[K|M|G])??????????????????????????? 2??147??483??647 ????????????? n????? n ?????????????? nK??????????? n*1??024(n ????? 2??097??152)?????????? nM??????????? n*1??048??576(n ????? 2??048)?????????? nG??????????? n*1??073??741??824(n ?????? 2)??
???????????????????????? DATE??TIME ?? TIMESTAMP???????????????Щ?????????????????????????????Щ??????????????????????????????????
????*DATE??DATE ??????????????????(???o???)??????????Χ??? 0001 ?? 9999???·??????Χ??? 1 ?? 12?????????Χ??? 1 ?? n?????? n ?????????·??DATE ?г? 10 ??????
????*TIME??TIME ??????????????????(С??????????)??С???????Χ??? 0 ?? 24?????????????Χ????? 0 ?? 59?????С?? 24??????????????? 0??TIME ?г? 8 ??????
????*TIMESTAMP??TIMESTAMP ?????????????????(????????С??????????????)??????????Χ??? 0001 ?? 9999???·??????Χ??? 1 ?? 12?????????Χ??? 1 ?? n?????? n ?????????·??С???????Χ??? 0 ?? 24?????????????Χ????? 0 ?? 59?????????Χ??? 000000 ?? 999999?????С??? 24??????????????????????????? 0??TIMESTAMP ?г? 26 ?????????????????????????????? DATE??TIME ?? TIMESTAMP ??????????????????????????????????????????????????????????CHAR ????????(????? SQL ??“????(parts of speech)”)???????????????????????????????
????*??????????????????????????????????????? 8 ??????????????????????·??????????????????????
????*??????????????????????????????????? 4 ????????????????????С??????????????????????????????????????????????????????? 0??
????*?????????????????????????????????????? 16 ?????????????????????????????????????? yyyy-mm-dd-hh.mm.ss.nnnnnn?????????????????С?????????????????????????????????????????κ???????????????β????????????????????????λ??????