SET [NAMES|CHARACTER SET]

    ，SET CHARACTER SET 和 SET CHARSET 语句用于修改当前连接的变量 character_set_client，character_set_results 和 character_set_connection。

    SetNamesStmt:

    VariableAssignmentList:

    VariableAssignment:

    VariableAssignment

    CharsetName:

    StringName

    CharsetKw:

    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%';

    语句与 MySQL 完全兼容。如发现任何兼容性差异，请在 GitHub 上提交 。