You are viewing the documentation of TiDB v8.2 (DMR). PingCAP does not provide bug fixes for v8.2. Any bugs will be fixed in future releases. For general purposes, please use the latest LTS version of the TiDB database.
TiDB behaves the same as MySQL: https://dev.mysql.com/doc/refman/8.0/en/type-conversion.html