* create table * show default character set Table Create Table t_like CREATE TABLE `t_like` (\n `c1` varchar(8) default NULL\n) ENGINE=InnoDB DEFAULT CHARSET=ujis Database Create Database test CREATE DATABASE `test` /*!40100 DEFAULT CHARACTER SET utf8 */ Variable_name Value character_set_client ujis character_set_connection ujis character_set_database utf8 character_set_results ujis character_set_server utf8 character_set_system utf8 character_sets_dir /usr/share/mysql/charsets/ no index #1 あ あい あう no index #2 a abc ade using index #1 あい あう using index #2 abc ade