banner
RustyNail

RustyNail

coder. 【blog】https://rustynail.me 【nostr】wss://ts.relays.world/ wss://relays.world/nostr
HomeArchives

Solution to MySQL garbled characters in Docker

37
AI Translation
This post is translated from Chinese into English through AI.View Original
AI-generated summary
Create a new configuration file in the mapped directory and specify the encoding as utf8. The client, mysql, and mysqld sections should have default-character-set set to utf8mb4, and the mysqld section should also have character-set-client-handshake set to FALSE, character-set-server set to utf8mb4, and collation-server set to utf8mb4_unicode_ci.

Create a new configuration file in the mapped configuration file directory, and then specify the encoding as utf8 in it.

[client]
default-character-set = utf8mb4

[mysql]
default-character-set = utf8mb4

[mysqld]
character-set-client-handshake = FALSE
character-set-server = utf8mb4
collation-server = utf8mb4_unicode_ci
Loading...
Ownership of this post data is guaranteed by blockchain and smart contracts to the creator alone.