MySQL garbled problem in command line

1. Phenomena

On the command line, execute the SQL statement if it contains a question that says "Data too long for column name ' at row 1" or the result in the command line query, Chinese garbled 2. Analyze A. View the default encoding of the command line: Right-click the command line title bar--Properties--current code page B. Viewing the encoding of the client and result set in MySQL show variables like ' character% ';, you can see that the client and the result set encoding is UTF8 problem found, command line and MySQL encoding method is not the same as the result of garbled; 3. Workaround first stop the MySQL service, and then locate the My.ini in the MySQL installation directory, locate the client section, and change the default character to GBK OK.

MySQL garbled problem in command line