1、查看数据库字符集:show create database hello;2、查看数据库表的字符集:show table status from hello like 'dept';3、.查看表中所有列的字符集:use hello;show full columns from dept;