> ## Documentation Index
> Fetch the complete documentation index at: https://private-7c7dfe99-detect-table-modification.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

# Supported data types

> Page describing MySQL ClickPipe datatype mapping from MySQL to ClickHouse

Here is the supported data-type mapping for the MySQL ClickPipe:

| MySQL Type                           | ClickHouse type        | Notes                                                                                                                                                           |
| ------------------------------------ | ---------------------- | --------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| Enum                                 | LowCardinality(String) |                                                                                                                                                                 |
| Set                                  | String                 |                                                                                                                                                                 |
| Decimal                              | Decimal(76,38)         | Values exceeding 38 integer digits are ingested as zero.                                                                                                        |
| Bit                                  | UInt64                 |                                                                                                                                                                 |
| TinyInt                              | Int8                   | Supports unsigned.                                                                                                                                              |
| SmallInt                             | Int16                  | Supports unsigned.                                                                                                                                              |
| MediumInt, Int                       | Int32                  | Supports unsigned.                                                                                                                                              |
| BigInt                               | Int64                  | Supports unsigned.                                                                                                                                              |
| Serial                               | UInt64                 |                                                                                                                                                                 |
| Year                                 | Int16                  |                                                                                                                                                                 |
| TinyInt(1)                           | Bool                   |                                                                                                                                                                 |
| Float                                | Float32                | Precision on ClickHouse may differ from MySQL during initial load due to text protocol. `Float(p)` maps to `Float32` for `p <= 24` and `Float64` for `p >= 25`. |
| Double                               | Float64                | Precision on ClickHouse may differ from MySQL during initial load due to text protocol.                                                                         |
| TinyText, Text, MediumText, LongText | String                 |                                                                                                                                                                 |
| TinyBlob, Blob, MediumBlob, LongBlob | String                 |                                                                                                                                                                 |
| Char, Varchar                        | String                 |                                                                                                                                                                 |
| Long, Long Varchar                   | String                 |                                                                                                                                                                 |
| Binary, VarBinary                    | String                 |                                                                                                                                                                 |
| Long VarBinary                       | String                 |                                                                                                                                                                 |
| JSON                                 | String                 | MySQL only; MariaDB `json` is just an alias for `text` with a constraint.                                                                                       |
| Geometry & Geometry Types            | String                 | WKT (Well-Known Text). WKT may suffer from small precision loss.                                                                                                |
| UUID                                 | UUID                   | MariaDB only. Columns added during CDC are added as `String` holding the raw 16 bytes.                                                                          |
| INET4, INET6                         | String                 | MariaDB only.                                                                                                                                                   |
| Vector                               | Array(Float32)         | MySQL only; MariaDB is adding support soon.                                                                                                                     |
| Char Byte, Raw                       | String                 | MariaDB/Oracle-mode aliases for binary types.                                                                                                                   |
| Clob, Varchar2, XMLType              | String                 | MariaDB/Oracle-mode aliases for text types.                                                                                                                     |
| Number                               | Decimal                | MariaDB/Oracle-mode alias for `Decimal`.                                                                                                                        |
| Date                                 | Date32                 | 00 day/month mapped to 01.                                                                                                                                      |
| Time                                 | DateTime64(6)          | Time offset from unix epoch.                                                                                                                                    |
| Datetime, Timestamp                  | DateTime64(6)          | 00 day/month mapped to 01.                                                                                                                                      |