Data type mapping
The following table shows the corresponding data types between RisingWave and TiDB. For details on native RisingWave data types, see Overview of data types.| RisingWave type | TiDB type |
|---|---|
| BOOLEAN | BOOLEAN |
| SMALLINT | TINYINT/SMALLINT |
| INT | INT/MEDIUMINT |
| BIGINT | BIGINT |
| REAL | FLOAT |
| DOUBLE | DOUBLE |
| DECIMAL | DECIMAL |
| DATE | DATE |
| TIMESTAMP | DATETIME |
| TIME | TIME |
| TIMESTAMPTZ | TIMESTAMP |
| VARCHAR | VARCHAR/CHAR/TEXT/TINYTEXT/MEDIUMTEXT/LONGTEXT |
| BYTEA | VARBINARY/BINARY/BLOB/TINYBLOB/MEDIUMBLOB/LONGBLOB |
| JSONB | JSON |