SET [NAMES|CHARACTER SET]

    SetNamesStmt:

    VariableAssignmentList:

    VariableAssignmentList

    CharsetName:

    CharsetName

    StringName:

    CharsetKw:

    CharsetNameOrDefault:

    CharsetNameOrDefault

    1. +--------------------------+--------------------------------------------------------+
    2. | Variable_name            | Value                                                  |
    3. +--------------------------+--------------------------------------------------------+
    4. | character_sets_dir       | /usr/local/mysql-5.6.25-osx10.8-x86_64/share/charsets/ |
    5. | character_set_connection | utf8mb4                                                |
    6. | character_set_system     | utf8                                                   |
    8. | character_set_database   | utf8mb4                                                |
    9. | character_set_filesystem | binary                                                 |
    10. | character_set_server     | utf8mb4                                                |
    11. +--------------------------+--------------------------------------------------------+
    12. 8 rows in set (0.01 sec)
    1. SET NAMES utf8;
    1. SHOW VARIABLES LIKE 'character_set%';
    1. +--------------------------+--------------------------------------------------------+
    2. | Variable_name            | Value                                                  |
    3. +--------------------------+--------------------------------------------------------+
    5. | character_set_system     | utf8                                                   |
    6. | character_set_results    | utf8                                                   |
    7. | character_set_client     | utf8                                                   |
    8. | character_set_server     | utf8mb4                                                |
    9. | character_set_database   | utf8mb4                                                |
    10. | character_set_filesystem | binary                                                 |
    11. +--------------------------+--------------------------------------------------------+
    12. 8 rows in set (0.00 sec)
    1. Query OK, 0 rows affected (0.00 sec)
    1. SHOW VARIABLES LIKE 'character_set%';