IntelliJ IDEA connection to TiDB reports encoding mismatch error

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

Original topic: intellij idea 连接 tidb 报编码对不上的错误

| username: 林快乐etc

【TiDB Usage Environment】Production Environment / Testing / PoC
【TiDB Version】v6.6.0
【Reproduction Path】Operations performed that led to the issue: Error reported when connecting to TiDB using IDEA
【Encountered Issue: Problem Phenomenon and Impact】Error message as follows
image

【Resource Configuration】
【Attachments: Screenshots / Logs / Monitoring】

| username: 我是咖啡哥 | Original post link

SHOW COLLATION WHERE Charset = 'utf8mb4';

Check which collations are supported in the current version. Choose one from the list.
It seems that my 6.4 environment only supports utf8mb4_bin.

| username: 林快乐etc | Original post link

| username: db_user | Original post link

Let’s try this method.

| username: 林快乐etc | Original post link

It’s done, thank you.

| username: db_user | Original post link

:+1: No problem.

| username: system | Original post link

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