*代表常用的
java | sqlserver | oracle | mongo | mysql |
---|---|---|---|---|
string | varchar/char/nchar/nvarchar/varchar(max)/text | *nvarchar2/varchar2/char/nchar | string | varchar/char |
bigdecimal | numeric/decimal/money/smallmoney | *number | string | bigint |
int | int | *integer/number | int32 | tinyint/smallint/mediumint |
date | date/datetime | *date | date | date/year |
long | bigint | *long/number | int64 | integer |
byte[] | image/varbinary(max)/binary/timestamp | raw/long raw | binary | blob |
clob | ntext | *nclob/clob | object | text |
blob | image | blob | object | blob |
float | real | *float/binary_float/number | double | float |
double | float | *number/binary_double | double | double |
timestamp | datetime/smalldatetime | *timestamp | date | datetime/timestamp |
boolean | bit | number | boolean | bit |
short | smallint/tinyint | number | int32 | smallint |
md写表格显示不全,坑爹,看下图吧