latin1 collation is failing to insert value '0xf6'

[ramanich1]

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

CREATE TABLE t2 (a CHAR(5) CHARACTER SET latin1 COLLATE latin1_bin);
INSERT INTO t2 VALUES (0xf6);

2. What did you expect to see? (Required)

mysql>  INSERT INTO t2 VALUES (0xf6);
Query OK, 1 row affected (0.00 sec)

3. What did you see instead (Required)

mysql>  INSERT INTO t2 VALUES (0xf6);
ERROR 1366 (HY000): Incorrect string value '\xF6' for column 'a'

4. What is your TiDB version? (Required)

+-----------------------------------------------+
| version()                                     |
+-----------------------------------------------+
| 5.7.25-TiDB-v6.1.0-alpha-482-g81a852077-dirty |
+-----------------------------------------------+

[Defined2014]

Pls update to the newest TiDB, the insert should work fine, but it's an invalid character in TiDB, ref #18955