Can't create GBK table with collation

[Defined2014]

Bug Report

I think it's caused by #31208

1. Minimal reproduce step (Required)

create table t2 (a char(20), b char(20) charset utf8, c binary) charset gbk collate gbk_bin;

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

success

3. What did you see instead (Required)

mysql> create table t2 (a char(20), b char(20) charset utf8, c binary) charset gbk collate gbk_bin;
ERROR 1115 (42000): Unknown character set: 'gbk'

4. What is your TiDB version? (Required)

mysql> SELECT tidb_version();
+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| tidb_version()                                                                                                                                                                                                                                                                                                           |
+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Release Version: v5.5.0-alpha-23-gba5902115
Edition: Community
Git Commit Hash: ba590211544ed93c78e97dde3e1d7a97fba58f86
Git Branch: master
UTC Build Time: 2022-01-05 02:55:05
GoVersion: go1.17.2
Race Enabled: false
TiKV Min Version: v3.0.0-60965b006877ca7234adaced7890d7b029ed1306
Check Table Before Drop: false |
+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.01 sec)

[Defined2014]

/severity critical

[Defined2014]

/affects-5.4

[Defined2014]

/assign @xiongjiwei

[github-actions]

Please check whether the issue should be labeled with 'affects-x.y' or 'fixes-x.y.z', and then remove 'needs-more-info' label.