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 Go 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 Go always ingests timestamp data in UTC format, independent of the source timezone.