tidb 5.0.2 character set utf8mb4_general_ci is still case sensitive

[An0nymous0]

[xiongjiwei]

please check the result

SELECT VARIABLE_VALUE FROM mysql.tidb WHERE VARIABLE_NAME='new_collation_enabled';

ref https://docs.pingcap.com/tidb/stable/character-set-and-collation#new-framework-for-collations

[An0nymous0]

This problem occurred when I upgraded from 5.0.1 to 5.0.2.

It's good after modifying new_collation_enabled is ture,The document says that new_collations_enabled_on_first_bootstrap cannot be set for existing clusters. I added that it took effect after restarting.

Also is it related to #24541

[aytrack]

This problem occurred when I upgraded from 5.0.1 to 5.0.2.

It's good after modifying new_collation_enabled is ture,The document says that new_collations_enabled_on_first_bootstrap cannot be set for existing clusters. I added that it took effect after restarting.

Also is it related to #24541

Did you mean it took effect while you just edited the config and restarted the cluster? This should not take effect without deploying a new cluster.

[Defined2014]

No reply for a long time, so close this issue