1.clickhouse:
Array(Date)=TEXT Array(DateTime=TEXT Array(FLoat32)=TEXT Array(FLoat64)=TEXT Array(Int16)=TEXT Array(Int32)=TExT Array(Int64)=TEXT Array(Int8)TExT DateTime=DATETIME Anray(stringD=TExT Array(UInt16)=INT Arav(uInt32)=INT Array(UInt64)=INT Array(UInt8)=INT UInt16=SMALLINTC5) UInt32=INT(10)) UInt64=BIGINT(20) UInt8-TINYINT(3) Int8=TINYINT(4) Int16=SMALLINT(6) Int32=INT(11) Int64=BIGINT(20) FLoat32=FL0AT(24) FLoat64=D0UBLE(53) Fixedstring=CHAR(255) String=VARCHAR(255)
2.Oracle
Array(Date)=TEXT Array(DateTime=TEXT Array(FLoat32)=TEXT Array(FLoat64)=TEXT Array(Int16)=TEXT Array(Int32)=TExT Array(Int64)=TEXT Array(Int8)TExT DateTime=DATETIME Anray(stringD=TExT Array(UInt16)=INT Arav(uInt32)=INT Array(UInt64)=INT Array(UInt8)=INT UInt16=SMALLINTC5) UInt32=INT(10)) UInt64=BIGINT(20) UInt8-TINYINT(3) Int8=TINYINT(4) Int16=SMALLINT(6) Int32=INT(11) Int64=BIGINT(20) FLoat32=FL0AT(24) FLoat64=D0UBLE(53) Fixedstring=CHAR(255)
3.postgresql:
integer=INT int4=INT SmaLLint=SMALLINT int2=SMALLINT bigint=BIGINT int8=BIGINT reaL=FLOAT fLoat4=FLOAT double-precision=DouBLE fLoat8=D0UBLE characten_varying=VARCHAR(255) varchar=VARCHAR(255) bpchar=VARCHAR(255) gzgu character=CHAR(255) char=CHAR(255) afily teXt=LONGTEXT timestamp_without_time_zone=DATETIME timestampwith time_zone=TIMEsTAMP timestamp=TIMEsTAMP date=DATE time_without_time_zone=TIME numeric=DECIMAL booLean=TINYINT(1) bytea=BLOB
标签:INT,适配,数据库,mysql,TExT,BIGINT,TEXT,Array,255 From: https://www.cnblogs.com/goPush/p/17446135.html