This CREATE TABLE request creates the following table for a user whose default character type is Latin.
CREATE TABLE kanji_user.table_1, NO FALLBACK, NO BEFORE JOURNAL, NO AFTER JOURNAL ( clatin CHARACTER(5), ckanji1 CHARACTER(5) CHARACTER SET UNICODE, cgraphic CHARACTER(5) CHARACTER SET GRAPHIC, ckanjisjis CHARACTER(5) CHARACTER SET KANJISJIS, cunicode CHARACTER(5)) PRIMARY INDEX (clatin);
A SHOW TABLE request for this table returns the following CREATE TABLE SQL text, as expected.
CREATE TABLE kanji_user.table_1, NO FALLBACK, NO BEFORE JOURNAL, NO AFTER JOURNAL ( clatin CHARACTER(5) CHARACTER SET LATIN, ckanji1 CHARACTER(5) CHARACTER SET UNICODE, cgraphic CHARACTER(5) CHARACTER SET GRAPHIC, ckanjisjis CHARACTER(5) CHARACTER SET KANJISJIS, cunicode CHARACTER(5) CHARACTER SET LATIN) PRIMARY INDEX ( clatin );