Garbled Chinese data is returned for query of data in GBK encoding

Symptom

Garbled Chinese characters appear in the result of a query in a tenant in GBK encoding format.

Possible causes

The encoding formats of the database connection, result set, and client are different.

Affected versions

All versions of client ODC and web ODC

Solutions

In ODC, choose Sessions > Session Properties and modify the session-level encoding. Ensure that the following three parameters are all utf8mb4:

• character_set_client: the client encoding.

• character_set_connection: the connection encoding.

• character_set_results: the result set encoding.