15.7.6.2 SET CHARACTER SET Statement (original) (raw)

15.7.6.2 SET CHARACTER SET Statement

SET {CHARACTER SET | CHARSET}
    {'charset_name' | DEFAULT}

This statement maps all strings sent between the server and the current client with the given mapping. SET CHARACTER SET sets three session system variables:character_set_client andcharacter_set_results are set to the given character set, andcharacter_set_connection to the value ofcharacter_set_database. SeeSection 12.4, “Connection Character Sets and Collations”.

charsetname may be quoted or unquoted.

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. SeeImpermissible Client Character Sets.