Last updated:|... min read
| MySQL Data Types | Destination Data Type |
|---|---|
| int, int unsigned, mediumint, mediumint unsigned, smallint, smallint unsigned, tinyint, tinyint unsigned | int |
| bigint, bigint unsigned | bigint |
| float, decimal(10,2) | float |
| double, double precision, real | double |
| datetime, timestamp | timestamptz |
| char, varchar, text, tinytext, mediumtext, longtext, enum, json, bit(1), time | string |
INT UNSIGNED mapping change
From OLake version 0.4.1 and above, INT UNSIGNED maps to bigint in the destination. In versions earlier than 0.4.1, it maps to int.
timestamptz timezone
OLake always ingests timestamp data in UTC format, independent of the source timezone.