Oracle & TDSQL数据类型对照表大类型字符类型Oracle数据类型CHAR(n), CHARACTER(n), n < 256CHAR(n), CHARACTER(n), n > 255VARCHAR(n),VARCHAR2(n)MySQL可匹配的数据类型CHAR(n), CHARACTER(n)VARCHAR(n)VARCHAR(n)NUMBER(p,0), NUMBER(p), 1 <= p < 3TINYINT数字类型NUMBER(p,0), NUMBER(p), 3 <= p < 5SMALLINTNUMBER(p,0), NUMBER(p), 5 <= p < 9NUMBER(p,0), NUMBER(p), 9 <= p < 19NUMBER(p,0), NUMBER(p), 19 <= p <=NUMBER(p,s), s > 0NUMBER, NUMBER(*)NUMERIC(p,s)SMALLINTREALINTEGER, INTDECIMAL(p,s), DEC(p,s)FLOAT(p)DATETIMESTAMP(p)TIMESTAMP(p) WITH TIME ZONEINTERVAL YEAR(p) TO MONTHINTERVAL DAY(p) TO SECOND(s)BFILECLOBINTBIGINTDECIMAL(p)DECIMAL(p,s)DOUBLENUMERIC(p,s)DECIMAL(38)DOUBLEINTDECIMAL(p,s), DEC(p,s)DOUBLEDATETIMEDATETIME(p)DATETIME(p)VARCHAR(30)VARCHAR(30)VARCHAR(255)LONGTEXTLONGBLOB日期类型BLOB大对象类型RAW(n),n < 256RAW(n), n > 255XMLTYPELONGLONG RAWROWIDBINARY(n)VARBINARY(n)LONGTEXTLONGTEXTLONGBLOBCHAR(10)其他备注：粗体为常用类型，斜体为不常用类型。
推荐使用数据类型CHAR(n)VARCHAR(n)VARCHAR(n)TINYINTSMALLINTINTBIGINTDECIMAL(p)DECIMAL(p,s)DOUBLEDATETIMEDATETIME(p)DATETIME(p)VARCHAR(255)LONGTEXTLONGBLOB