SHOW VARIABLES LIKE "%CHAR%";
CREATE DATABASE IF NOT EXISTS test;
USE test;

CREATE TABLE table_coupon (
  coupon_no varchar(10) NOT NULL DEFAULT '',
  memo varchar(30) DEFAULT NULL,
  discount double DEFAULT NULL,
  PRIMARY KEY (coupon_no)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
INSERT INTO table_coupon VALUES ('1','ＡＢＣ',250),('2','ＤＥ Ｆ',200),('3','ＧＨＩ',300);
SELECT * FROM table_coupon;

GRANT ALL ON test.* TO 'root'@'10.0.1.33';
