MySQL的Other Vendor Type
Other Vendor Type | MySQL Type | 占用字节数 |
---|---|---|
BOOL | TINYINT | 1字节 |
BOOLEAN | TINYINT | 1字节 |
CHARACTER VARYING(M) | VARCHAR(M) | 0~65535字节 |
FIXED | DECIMAL | - |
FLOAT4 | FLOAT | 4字节 |
FLOAT8 | DOUBLE | 8字节 |
INT1 | TINYINT | 1字节 |
INT2 | SMALLINT | 2字节 |
INT3 | MEDIUMINT | 3字节 |
INT4 | INT | 4字节 |
INT8 | BIGINT | 8字节 |
LONG VARBINARY | MEDIUMBLOB | 16777215字节 |
LONG VARCHAR | MEDIUMTEXT | 16777215字节 |
LONG | MEDIUMTEXT | 16777215字节 |
MIDDLEINT | MIDDLEINT | 3字节 |
NUMERIC | DECIMAL | - |