Great introduction article. Based on the document and show collation output from TiDB 5.1.1, TiDB does not support utf8mb4_general_ci. Then this database.yml may need to be updated as follows?
show collation
utf8mb4_general_ci
collation: utf8mb4_general_ci
collation: utf8mb4_bin
Character sets and collations supported by TiDB docs.pingcap.com/tidb/stable/chara...
show collation output from TiDB 5.1.1
Server version: 5.7.25-TiDB-v5.1.1 TiDB Server (Apache License 2.0) Community Edition, MySQL 5.7 compatible Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MySQL [(none)]> show collation; +-------------+---------+------+---------+----------+---------+ | Collation | Charset | Id | Default | Compiled | Sortlen | +-------------+---------+------+---------+----------+---------+ | utf8mb4_bin | utf8mb4 | 46 | Yes | Yes | 1 | | latin1_bin | latin1 | 47 | Yes | Yes | 1 | | binary | binary | 63 | Yes | Yes | 1 | | ascii_bin | ascii | 65 | Yes | Yes | 1 | | utf8_bin | utf8 | 83 | Yes | Yes | 1 | +-------------+---------+------+---------+----------+---------+ 5 rows in set (0.00 sec) MySQL [(none)]>
Yes. when new_collations_enabled_on_first_bootstrap = true is set, utf8mb4_general_ci is avaliable. I missed this tidb cluster setting.
new_collations_enabled_on_first_bootstrap = true
Are you sure you want to hide this comment? It will become hidden in your post, but will still be visible via the comment's permalink.
Hide child comments as well
Confirm
For further actions, you may consider blocking this person and/or reporting abuse
We're a place where coders share, stay up-to-date and grow their careers.
Great introduction article.
Based on the document and
show collation
output from TiDB 5.1.1, TiDB does not supportutf8mb4_general_ci
.Then this database.yml may need to be updated as follows?
Character sets and collations supported by TiDB
docs.pingcap.com/tidb/stable/chara...
show collation
output from TiDB 5.1.1Yes. when
new_collations_enabled_on_first_bootstrap = true
is set, utf8mb4_general_ci is avaliable. I missed this tidb cluster setting.