How to Modify the Collation of Execution Plan Bindings

Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.

Original topic: 如何修改执行计划绑定的排序规则

| username: 路在何chu

[TiDB Usage Environment] Production Environment
4013
[Reproduction Path] What operations were performed when the problem occurred
Binding execution plan
show global bindings\G
*************************** 1. row ***************************
Original_sql: select xx ORDER BY id DESC LIMIT 100
Default_db: nxxx
Status: using
Create_time: 2024-03-22 01:56:53.457
Update_time: 2024-03-22 01:56:53.457
Charset: utf8mb4
Collation: utf8mb4_bin
Source: manual
[Encountered Problem: Problem Phenomenon and Impact]
Collation is case-sensitive with utf8mb4_bin, how to change it to utf8mb4_general_ci

| username: Kamner | Original post link

| username: 路在何chu | Original post link

Cannot modify, can only set the environment to rebind.

| username: TiDBer_rvITcue9 | Original post link

Backup, Modify, Restore

| username: system | Original post link

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.