Table 1 lists MySQL data types supported by CRS.
Table 1 Correspondence between MySQL data types and CRS field typesMySQL Data Type | CRS Field Type |
|---|
TINYINT | Integer |
SMALLINT |
MEDIUMINT |
INT/INTEGER |
BIGINT |
FLOAT | Double |
DOUBLE |
DECIMAL |
CHAR | String |
VARCHAR |
TINYTEXT |
TEXT |
TIME |
YEAR |
DATE | Date |
DATETIME |
TIMESTAMP |
For the purpose of data analysis performance, CRS does not support the following MySQL data types:
- TINYBLOB
- BLOB
- MEDIUMBLOB
- MEDIUMTEXT
- LONGBLOB
- LONGTEXT