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

The following content mainly brings you the operation process of information_schema database. The knowledge mentioned here is slightly different from books. It is summarized by professional technicians in the process of contacting users. It has certain experience sharing value and hopes to bring help to readers.

Select the information_schema database in the database. The information stored in this database is the encoded information of mysql database.

Select the information_schema database, and enter the following MYSQL statement in the database interrupt to perform related operations.

Query SQL statements that support Unicode

SELECT * FROM CHARACTER_SETS WHERE DESCRIPTION LIKE '%Unicode';

Query results found support for: ucs2, utf8, utf8 mb4, utf16, utf16 le, utf32.

View Cloud Virtual Machine default encoding: SHOW VARIABLES LIKE 'character_set_server';

Set server code: SET character_set_server='utf8';

VIEW CHARACTER SET PROOF RULES SHOW VARIABLES LIKE 'collection_server';

SET collation_server ='utf8_general_ci ';

View all proofreading rules SET COLLATION;

For the above information_schema database operation process, if you still need to know more, you can continue to pay attention to our industry promotion. If you need to get professional answers, you can contact the pre-sales and after-sales on the official website. I hope this article can bring you some knowledge updates.

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.