In addition to Weibo, there is also WeChat
Please pay attention
WeChat public account
Shulou
2025-03-29 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >
Share
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.
Views: 0
*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.
Continue with the installation of the previous hadoop.First, install zookooper1. Decompress zookoope
"Every 5-10 years, there's a rare product, a really special, very unusual product that's the most un
© 2024 shulou.com SLNews company. All rights reserved.