In addition to Weibo, there is also WeChat
Please pay attention
WeChat public account
Shulou
2025-09-24 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.
The market share of Chrome browser on the desktop has exceeded 70%, and users are complaining about
The world's first 2nm mobile chip: Samsung Exynos 2600 is ready for mass production.According to a r
A US federal judge has ruled that Google can keep its Chrome browser, but it will be prohibited from
Continue with the installation of the previous hadoop.First, install zookooper1. Decompress zookoope
About us Contact us Product review car news thenatureplanet
More Form oMedia: AutoTimes. Bestcoffee. SL News. Jarebook. Coffee Hunters. Sundaily. Modezone. NNB. Coffee. Game News. FrontStreet. GGAMEN
© 2024 shulou.com SLNews company. All rights reserved.