mysql character set processing

Character set issues involving database connections and backups

Status check

Check the character set status in the database

show characters set; --List all character sets supported by MYSQL

SHOW VARIABLES LIKE 'character_set_%'; --Current MYSQL server character set settings

show variables like 'collation%'; --Current character set comparison settings

Relationship of environment variables

– character_set_server: the default internal operating character set

– character_set_client: the character set used by the client source data

– character_set_connection: connection layer character set

– character_set_results: Query result character set

– character_set_database: The default character set of the currently selected database

– character_set_system: System metadata (field name, etc.) character set

– Also There are variables corresponding to the above starting with collation_, used to describe the character sequence

+-------------------------- --+------------------+

| Variable_name | Value |

+--------- -------------+-------------------+

| collation_connection | latin1_swedish_ci |

| collation_database | latin1_swedish_ci |

| collation_server | latin1_swedish_ci |

+----------------------+--- ----------------+

The above is the content of mysql character set processing. For more related content, please pay attention to the PHP Chinese website (www.php.cn )!