| MySQL | Postgres | SQLite | CUBRID | Min | Max | Storage |
|---|---|---|---|---|---|---|
| TINYINT (3) | * | * | * | -128 | 127 | 1byte |
| tinyint unsigned | * | * | * | 0 | 255 | 1byte |
| SMALLINT (5) | SMALLINT | * | SMALLINT | -32768 | 32767 | 2bytes |
| smallint unsigned | * | * | * | 0 | 65535 | 2bytes |
| INT (10) | INT | INT | INT | -2147483648 | 2147483647 | 4bytes |
| int unsigned | * | * | * | 0 | 4294967295 | 4bytes |
| BIGINT (20) | BIGINT | * | BIGINT | -9223372036854775808 | 9223372036854775807 | 8bytes |
| SERIAL | SERIAL | * | * | my:bigint unsigned not null unique | pg:int not null default nextval('tab_col_seq') | |
| * | BIGSERIAL | * | * | bigint not null default nextval('tab_col_seq') | 8bytes | |
| FLOAT | NUMERIC | REAL | NUMERIC | my:-3.402823466E+38 to -1.175494351E-38, 0, and 1.175494351E-38 to 3.402823466E+38 pg:131072-digit.16383-digit | 4bytes | |
| ENUM | * | * | * | max 65K val | 2bytes | |
| MySQL | Postgres | SQLite | CUBRID | Min | Max | Storage |
| DATE | DATE | * | DATE | my:1000-01-01 pg:4713-01-01 BC cb:0001-01-01 | my:9999-12-31 pg:9999-12-31 :) cb:9999-12-31 | 3bytes 4bytes |
| TIME | TIME | * | TIME | 00:00:00 | 23:59:59 | 3bytes |
| TIMESTAMP default now() | TIMESTAMP default now() | * | TIMESTAMP | my:1970-01-01 00:00:01 pg:4713-01-01 00:00:00 BC | my:2038-01-19 03:14:07 pg:9999-12-31 00:00:00 | 8bytes |
| MySQL | Postgres | SQLite | CUBRID | Max |
| CHAR | CHAR | * | CHAR | 255 |
| VARCHAR | VARCHAR | * | VARCHAR | 255 (My5.0.3+ max 65K) PG 1G |
| TEXT | TEXT | TEXT | VARCHAR | My 65K PG 1G |
| MEDIUMTEXT | * | * | VARCHAR | 16M |
| LONGTEXT | * | * | * | 4G |
| BLOB | BYTEA | BLOB | * | My 65K PG 1G |