The following table lists the data type mappings for MySQL to PostgreSQL.
|
MYSQL TO POSTGRESQL DATA TYPE MAPPINGS | |
|---|---|
|
Hyperstage MySQL Data Type |
Hyperstage PostgreSQL Data Type |
|
BOOL |
SMALLINT |
|
TINYINT |
SMALLINT |
|
MEDIUMINT |
INT |
|
INT |
INT |
|
BIGINT |
BIGINT |
|
FLOAT |
REAL |
|
DOUBLE |
DOUBLE PRECISION |
|
DECIMAL(M,N) |
DECIMAL(M,N) |
|
YEAR |
(To be decided) |
|
TIME |
INTERVAL HOUR TO SECOND |
|
DATE |
DATE |
|
DATETIME |
TIMESTAMP WITHOUT TIME ZONE) |
|
TIMESTAMP |
TIMESTAMP WITH TIME ZONE) |
|
CHAR(N) |
CHAR(N) |
|
VARCHAR(N) |
VARCHAR(N) |
|
TINYTEXT |
VARCHAR(255) |
|
TEXT |
VARCHAR(N) |
|
BINARY(N) |
BYTEA(N) |
|
VARBINARY(N) |
BYTEA(N) |
| WebFOCUS |