Sink data from RisingWave to TiDB with the JDBC connector

For the syntax, settings, and examples, see Sink data from RisingWave to MySQL with the JDBC connector.

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

Turbopuffer CockroachDB

⌘I

Get started

Work with data

Install & Operate

Performance

Troubleshooting

Reference

Cloud

Sink data from RisingWave to TiDB with the JDBC connector

Data type mapping

​Data type mapping

Data type mapping