MySQL的Other Vendor Type
mysql8参考文档
| Other Vendor Type | MySQL Type | 占用字节数 |
|---|---|---|
| BOOL | TINYINT | 1字节 |
| BOOLEAN | TINYINT | 1字节 |
| CHARACTER VARYING(M) | VARCHAR(M) | ０～65535字节 |
| FIXED | DECIMAL | － |
| FLOAT4 | FLOAT | ４字节 |
| FLOAT8 | DOUBLE | ８字节 |
| INT1 | TINYINT | １字节 |
| INT2 | SMALLINT | ２字节 |
| INT3 | MEDIUMINT | ３字节 |
| INT4 | INT | ４字节 |
| INT8 | BIGINT | ８字节 |
| LONG VARBINARY | MEDIUMBLOB | 16777215字节 |
| LONG VARCHAR | MEDIUMTEXT | 16777215字节 |
| LONG | MEDIUMTEXT | 16777215字节 |
| MIDDLEINT | MIDDLEINT | 3字节 |
| NUMERIC | DECIMAL | - |