# Handling tinyint(1) in MySQL

> Source: https://docs.synthesized.io/tdk/latest/user_guide/080_troubleshooting/database_specific/tinyint1_in_mysql
> For the complete documentation index, see [llms.txt](https://docs.synthesized.io/llms.txt).

When copying a MySQL schema, `TINYINT(1)` fields in the source database can sometimes be transformed into `BIT(1)` in the target database. To prevent `TINYINT(1)` from being converted to `BIT(1)`, set the `tinyInt1isBit` JDBC parameter to `false` in the connection URL for the source database. For example:

```console
jdbc:mysql://127.0.0.1:6000/sakila?tinyInt1isBit=false
```

Here’s a full example of the command for starting TDK transformation:

```console
tdk \
    --input-url jdbc:mysql://127.0.0.1:6000/sakila?tinyInt1isBit=false \
    --input-username root --input-password admin \
    --output-url jdbc:mysql://127.0.0.1:6001/ \
    --output-username root --output-password admin \
    --config-file config.tdk.yaml
```

More detailed information about `tinyInt1isBit` parameter is available in the [documentation](https://dev.mysql.com/doc/connector-j/en/connector-j-connp-props-result-sets.html). Additional information about MySQL type conversions [here](https://dev.mysql.com/doc/connector-j/en/connector-j-reference-type-conversions.html).