You are viewing the documentation of an older version of the TiDB database (TiDB v5.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