pingcap / pingcap/tidb

support variable of `default_collation_for_utf8`

Open
#63,328 14 comments 0 reactions 0 assignees View on GitHub
contribution first-time-contributor type/feature-request
Dominant language
Go
Stars
40.5k
Forks
6.2k
PR merge metrics
PR metrics pending

Description

## Feature Request

My application originally used a MySQL database. When creating tables with the utf8 charset, the expected collation was utf8_general_ci.

Since the default collation for utf8 in TiDB is utf8_bin, I need to modify either the business logic or the CREATE TABLE statements.

However, because a large number of applications are involved, modifying the business logic or the CREATE TABLE statements is difficult to execute.

Therefore, I hope to add a system variable to set the default collation for the utf8 charset.

TiDB already supports default_collation_for_utf8mb4, so the same logic can be implemented.

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.