The default character set mapping can be restored by using the value DEFAULT . The default depends on the server configuration. 

Some character sets cannot be used as the client character set. Attempting to use them with SET CHARACTER SET  produces an error. See Impermissible Client Character Sets. 

## 13.7.6.3 SET NAMES Statement 

SET NAMES {’ charset_name ’ [COLLATE ’ collation_name ’] | DEFAULT} 

This statement sets the three session system variables character_set_client , character_set_connection , and character_set_results  to the given character set. Setting character_set_connection  to charset_name  also sets collation_connection  to the default collation for charset_name . See Section 10.4, “Connection Character Sets and Collations” . 

The optional COLLATE  clause may be used to specify a collation explicitly. If given, the collation must one of the permitted collations for charset_name . 

charset_name  and collation_name  may be quoted or unquoted. 

The default mapping can be restored by using a value of DEFAULT . The default depends on the server configuration. 

Some character sets cannot be used as the client character set. Attempting to use them with SET NAMES produces an error. See Impermissible Client Character Sets. 

## 13.7.7 SHOW Statements 

SHOW  has many forms that provide information about databases, tables, columns, or status information about the server. This section describes those following: 

SHOW {BINARY | MASTER} LOGS SHOW BINLOG EVENTS [IN ’ log_name ’] [FROM pos ] [LIMIT [ offset ,] row_count ] SHOW CHARACTER SET [ like_or_where ] SHOW COLLATION [ like_or_where ] SHOW [FULL] COLUMNS FROM tbl_name  [FROM db_name ] [ like_or_where ] SHOW CREATE DATABASE db_name SHOW CREATE EVENT event_name SHOW CREATE FUNCTION func_name SHOW CREATE PROCEDURE proc_name SHOW CREATE TABLE tbl_name SHOW CREATE TRIGGER trigger_name SHOW CREATE VIEW view_name SHOW DATABASES [ like_or_where ] SHOW ENGINE engine_name  {STATUS | MUTEX} SHOW [STORAGE] ENGINES SHOW ERRORS [LIMIT [ offset ,] row_count ] SHOW EVENTS SHOW FUNCTION CODE func_name SHOW FUNCTION STATUS [ like_or_where ] SHOW GRANTS FOR user SHOW INDEX FROM tbl_name  [FROM db_name ] SHOW MASTER STATUS SHOW OPEN TABLES [FROM db_name ] [ like_or_where ] SHOW PLUGINS SHOW PROCEDURE CODE proc_name SHOW PROCEDURE STATUS [ like_or_where ] SHOW PRIVILEGES SHOW [FULL] PROCESSLIST SHOW PROFILE [ types ] [FOR QUERY n ] [OFFSET n ] [LIMIT n ] 

