Data Replication
- Data Replication 9.7.0
- All Products
MySQL Source Datatype | Amazon Redshift Target Datatype | Comments |
---|---|---|
BIGINT | DECIMAL(20,0) | - |
BIT | DECIMAL(20,0) | - |
CHAR( n ) | CHAR( n ) | - |
DATE | DATE | - |
DATETIME | TIMESTAMP | - |
DECIMAL( p ,s ) |
| - |
DOUBLE | DOUBLE PRECISION | - |
ENUM | VARCHAR(255) | - |
FLOAT | REAL | - |
INT | BIGINT | - |
LONGTEXT | VARCHAR(65000) | - |
MEDIUMINT | INTEGER | - |
MEDIUMTEXT | VARCHAR(65000) | - |
SET | VARCHAR(4000) | - |
SMALLINT | INTEGER | - |
TEXT | VARCHAR(65000) | - |
TIME | TIMESTAMP | - |
TIMESTAMP | TIMESTAMP | - |
TINYINT | SMALLINT | - |
TINYTEXT | VARCHAR(256) | - |
VARCHAR( n ) | VARCHAR( n ) | - |
YEAR | INTEGER | - |