Shulou(Shulou.com)06/01 Report--

The character set used by character_set_client to issue SQL statements on the client side.

Proofreading rules for character sets used by collation_connection connections

The character set used by character_set_results to return query result sets (such as query results or error messages) to the client

Character_set_connection The character set used for literals that do not have a character set introducer and for number-to-string conversion

-- specifies the character set used by the client for the current session

SET NAMES changes the character set of the three session parameters character_set_client and character_set_connection,character_set_results at the same time.

Mysql > set names utf8

Query OK, 0 rows affected (0.00 sec)

Mysql > show variables like'% character%'

+-+

| | Variable_name | Value |

+-+

| | character_set_client | utf8 |

| | character_set_connection | utf8 |

| | character_set_database | gbk |

| | character_set_filesystem | binary |

| | character_set_results | utf8 |

| | character_set_server | gbk |

| | character_set_system | utf8 |

| | character_sets_dir | / data/share/charsets/ |

+-+

8 rows in set (0.00 sec)

SET CHARACTER SET changes character_set_client and character_set_results, and sets character_set_connection to the value of the system parameter character_set_database

Mysql > set character set latin2

Query OK, 0 rows affected (0.01 sec)

Mysql > show variables like'% character%'

+-+

| | Variable_name | Value |

+-+

| | character_set_client | latin2 |

| | character_set_connection | gbk |

| | character_set_database | gbk |

| | character_set_filesystem | binary |

| | character_set_results | latin2 |

| | character_set_server | gbk |

| | character_set_system | utf8 |

| | character_sets_dir | / data/share/charsets/ |

+-+

8 rows in set (0.00 sec)

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.