ORMTYPE | SQL | MYSQL |
---|---|---|
big_decimal | DECIMAL, MONEY | DECIMAL |
binary | BINARY, VARBINARY | TINYBLOB |
blob | TINYBLOB | |
Boolean | [SMALLINT], BIT | BIT |
clob | LONGTEXT | |
date | DATE | DATE |
double | DOUBLE, MONEY, NUMERIC | DOUBLE |
character, char | CHAR | |
float | REAL, FLOAT | FLOAT |
integer, int | INT | INT |
long | BIGINT | BIGINT |
serializable | TINYBLOB | |
short | SMALLINT | SMALLINT |
string | CHAR, NCHAR, VARCHAR, NVARCHAR | VARCHAR |
text | TEXT, NTEXT | LONGTEXT |
timestamp | DATETIME, SMALLDATETIME, TIMESTAMP | DATETIME |
true_false | CHAR | |
yes_no | CHAR |