You are viewing the documentation of an older version of the TiDB database (TiDB v3.0). It is recommended that you use the latest LTS version of the TiDB database.
TiDB behaves the same as MySQL: https://dev.mysql.com/doc/refman/5.7/en/type-conversion.html