Zenn
Closed2

Mysql 調査

MySQL
DB
EightTEightT

https://dev.mysql.com/doc/refman/5.7/en/charset-connection.html

What character set are statements in when they leave the client?

The server takes the character_set_client system variable to be the character set in which statements are sent by the client.

mysql> SELECT * FROM performance_schema.session_variables
    -> WHERE VARIABLE_NAME IN (
    -> 'character_set_client', 'character_set_connection',
    -> 'character_set_results', 'collation_connection'
    -> ) ORDER BY VARIABLE_NAME;
+--------------------------+-----------------+
| VARIABLE_NAME            | VARIABLE_VALUE  |
+--------------------------+-----------------+
| character_set_client     | utf8            |
| character_set_connection | utf8            |
| character_set_results    | utf8            |
| collation_connection     | utf8_general_ci |
+--------------------------+-----------------+
4 rows in set (0.01 sec)
このスクラップは5ヶ月前にクローズされました