MarialDB 建库设置中文字符

CREATE DATABASE newdatabasename CHARACTER SET = utf8 COLLATE = utf8_general_ci;

show variables like "character_set_%" #查看默认编码

set character_set_database=utf8; #修改编码

show variables like "collation_%"; #查看连接编码

#修改连接层编码
SET NAMES 'utf8';
/*
它相当于下面的三句指令： 
SET character_set_client = utf8; 
SET character_set_results = utf8; 
SET character_set_connection = utf8; 

ALTER database databasename character set utf8; #修改数据库编码