-- https://dev.mysql.com/doc/refman/8.0/en/charset-database.html show variables like "character_set_%"; CREATE DATABASE `geovindu` CHARACTER SET utf8 COLLATE utf8_general_ci; -- mysql官方说明文档才知道原来MySQL8.0已经已经把默认字符集升级成ut8mb4了 ALTER DATABASE geovindu DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_general_ci ; SELECT DEFAULT_CHARACTER_SET_NAME, DEFAULT_COLLATION_NAME FROM INFORMATION_SCHEMA.SCHEMATA WHERE SCHEMA_NAME = 'geovindu'; USE geovindu; SELECT @@character_set_database, @@collation_database;
标签:set,DEFAULT,utf8,character,geovindu,mysql From: https://www.cnblogs.com/geovindu/p/17364011.html