1, mysql Chinese garbled problem, in the sql connection tool, the front-end display of Chinese content is normal, utf8 code, but I use secureCRT to connect to mysql on the machine, then select out is garbled
If you use mysl-uroot-proot-default-character-set = utf8 connection, it will display normally.
Therefore, I want to change mysql's configuration, change /etc/my.cnf, and add the last two lines:
Restarting mysql is still not effective. Please look at the great god help, mysql version:
If you confirm that mysql’s own encoding setting is correct and the stored data is normal in Chinese, shouldn’t you modify the character encoding displayed in SecureCRT terminal configuration?