wakuchin

kjmtsh様
ご助言どうもありがとうございます！！

phpMyAdmin にログインし、SQLのタブで３つの文を実行してみました。
以下、ご報告致します。

1.
SHOW VARIABLES LIKE 'character%';

Variable_name: Value
character_set_client: utf8
character_set_connection: utf8
character_set_database: ujis
character_set_filesystem: binary
character_set_results: utf8
character_set_server: ujis
character_set_system: utf8
character_sets_dir: /usr/local/share/mysql/charsets/

2.
SHOW VARIABLES LIKE 'collation%'

Variable_name: Value
collation_connection: utf8_general_ci
collation_database: ujis_japanese_ci
collation_server: ujis_japanese_ci

3.
SHOW CREATE TABLE データベース名.wp_posts;

Table: Create Table
wf_wp_posts: CREATE TABLE wf_wp_posts (
ID bigint(20) unsigned NOT NULL AUTO_INCREMENT,
post_author bigint(20) unsigned NOT NULL DEFAULT ‘0’,
post_date datetime NOT NULL DEFAULT ‘0000-00-00 00:00:00’,
post_date_gmt datetime NOT NULL DEFAULT ‘0000-00-00 00:00:00’,
post_content longtext NOT NULL,
post_title text NOT NULL,
post_category int(4) NOT NULL DEFAULT ‘0’,
post_excerpt text NOT NULL,
post_status varchar(20) NOT NULL DEFAULT ‘publish’,
comment_status varchar(20) NOT NULL DEFAULT ‘open’,
ping_status varchar(20) NOT NULL DEFAULT ‘open’,
post_password varchar(20) NOT NULL DEFAULT ”,
post_name varchar(200) NOT NULL DEFAULT ”,
to_ping text NOT NULL,
pinged text NOT NULL,
post_modified datetime NOT NULL DEFAULT ‘0000-00-00 00:00:00’,
post_modified_gmt datetime NOT NULL DEFAULT ‘0000-00-00 00:00:00’,
post_content_filtered longtext NOT NULL,
post_parent bigint(20) unsigned NOT NULL DEFAULT ‘0’,
guid varchar(255) NOT NULL DEFAULT ”,
menu_order int(11) NOT NULL DEFAULT ‘0’,
post_type varchar(20) NOT NULL DEFAULT ‘post’,
post_mime_type varchar(100) NOT NULL DEFAULT ”,
comment_count bigint(20) NOT NULL DEFAULT ‘0’,
PRIMARY KEY (ID),
KEY type_status_date (post_type,post_status,post_date,ID),
KEY post_parent (post_parent),
KEY post_author (post_author),
KEY post_name (post_name(191))
) ENGINE=MyISAM AUTO_INCREMENT=19605 DEFAULT CHARSET=ujis

どうぞよろしくお願い致します。