| 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 |
