Description:
skip-character-set-client-handshake is not listed in SHOW VARIABLES.
In order to know that skip-character-set-client-handshake is enabled, we have to check if the values related to the client character set (character_set_client, character_set_connection and character_set_results) are same as character_set_database like below.
mysql> SHOW VARIABLES LIKE 'char%';
+--------------------------+----------------------------------------+
| Variable_name | Value |
+--------------------------+----------------------------------------+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | utf8 |
| character_set_filesystem | binary |
| character_set_results | utf8 |
| character_set_server | utf8 |
| character_set_system | utf8 |
| character_sets_dir | /usr/local/mysql/share/mysql/charsets/ |
+--------------------------+----------------------------------------+
8 rows in set (0.01 sec)
When the client which uses the different charset accesses to MySQL server, skip-character-set-client-handshake in SHOW VARIABLES is much more useful and needed.
How to repeat:
mysql> SHOW VARIABLES LIKE '%character-set-client-handshake';
Empty set (0.00 sec)
Suggested fix:
Please add skip-character-set-client-handshake to SHOW VARIABLES list.