How to set mycli character encoding set?

dbcli / mycli

A Terminal Client for MySQL with AutoCompletion and Syntax Highlighting.

http://mycli.net

Other

11.39k stars 657 forks source link

Open ICLXL opened 3 years ago

ICLXL commented 3 years ago

I get the data in my mysql server cli normally, but the data through mycli is garbled.

rolandwalker commented 3 years ago

Hi!

Currently the best way is to set

[client]
default-character-set = utf8mb4

in ~/.my.cnf.

But in #915, @seamile is also working on a --charset CLI option to change the character set for individual connections.