Error executing query: 1105 (HY000): invalid collation utf8mb4_0900_ai_ci

[xunzhang123]

Execute an SQL query to retrieve the first three rows of my budget table.

{
"query": "SELECT * FROM budget LIMIT 3;"
}

响应：Error executing query: 1105 (HY000): invalid collation utf8mb4_0900_ai_ci

Adjusting collation settings to match existing schema definitions.

mysql/execute_sql

参数

{
"query": "SELECT * FROM budget LIMIT 3 COLLATE utf8mb4_general_ci;"
}

响应

Error executing query: 1105 (HY000): invalid collation utf8mb4_0900_ai_ci

Adjusting connection collation to match table definition

mysql/execute_sql

参数

{
"query": "SET collation_connection = 'utf8mb4_bin'; SELECT * FROM budget LIMIT 3;"
}

响应

Error executing query: 1105 (HY000): invalid collation utf8mb4_0900_ai_ci

Adjusting connection charset and collation to match table definition exactly.

mysql/execute_sql

参数

{
"query": "SET NAMES utf8mb4 COLLATE utf8mb4_bin; SELECT * FROM budget LIMIT 3;"
}

响应

Error executing query: 1105 (HY000): invalid collation utf8mb4_0900_ai_ci

均不可以，如何解决（在不升级我的mysql版本或者更改表的字符集）