--------------
SHOW VARIABLES LIKE "%CHAR%"
--------------

+--------------------------+----------------------------+
| Variable_name            | Value                      |
+--------------------------+----------------------------+
| character_set_client     | utf8                       |
| character_set_connection | utf8                       |
| character_set_database   | utf8                       |
| character_set_filesystem | binary                     |
| character_set_results    | utf8                       |
| character_set_server     | utf8                       |
| character_set_system     | utf8                       |
| character_sets_dir       | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
8 rows in set (0.04 sec)

--------------
CREATE DATABASE IF NOT EXISTS test
--------------

Query OK, 1 row affected, 1 warning (0.00 sec)

Note (Code 1007): Can't create database 'test'; database exists
--------------
DROP TABLE IF EXISTS table_coupon_varchar
--------------

Query OK, 0 rows affected (0.01 sec)

--------------
CREATE TABLE table_coupon_varchar (
  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
--------------

Query OK, 0 rows affected (3.84 sec)

--------------
INSERT INTO table_coupon_varchar VALUES ('1','ＡＢＣ',250),('2','ＤＥ Ｆ',200),('3','ＧＨＩ',300)
--------------

Query OK, 3 rows affected (0.00 sec)
Records: 3  Duplicates: 0  Warnings: 0

--------------
SELECT * FROM table_coupon_varchar
--------------

+-----------+------------+----------+
| coupon_no | memo       | discount |
+-----------+------------+----------+
| 1         | ＡＢＣ     |      250 |
| 2         | ＤＥ Ｆ    |      200 |
| 3         | ＧＨＩ     |      300 |
+-----------+------------+----------+
3 rows in set (0.00 sec)

--------------
DROP TABLE IF EXISTS table_coupon_text
--------------

Query OK, 0 rows affected (0.02 sec)

--------------
CREATE TABLE table_coupon_text (
  coupon_no varchar(10) NOT NULL DEFAULT '',
  memo text DEFAULT NULL,
  discount double DEFAULT NULL,
  PRIMARY KEY (coupon_no)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
--------------

Query OK, 0 rows affected (0.28 sec)

--------------
INSERT INTO table_coupon_text VALUES ('1','ＡＢＣ',250),('2','ＤＥ Ｆ',200),('3','ＧＨＩ',300)
--------------

Query OK, 3 rows affected (0.01 sec)
Records: 3  Duplicates: 0  Warnings: 0

--------------
SELECT * FROM table_coupon_text
--------------

+-----------+------------+----------+
| coupon_no | memo       | discount |
+-----------+------------+----------+
| 1         | ＡＢＣ     |      250 |
| 2         | ＤＥ Ｆ    |      200 |
| 3         | ＧＨＩ     |      300 |
+-----------+------------+----------+
3 rows in set (0.00 sec)

--------------
DROP TABLE IF EXISTS table_coupon_mediumtext
--------------

Query OK, 0 rows affected (0.05 sec)

--------------
CREATE TABLE table_coupon_mediumtext (
  coupon_no varchar(10) NOT NULL DEFAULT '',
  memo mediumtext DEFAULT NULL,
  discount double DEFAULT NULL,
  PRIMARY KEY (coupon_no)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
--------------

Query OK, 0 rows affected (0.43 sec)

--------------
INSERT INTO table_coupon_mediumtext VALUES ('1','ＡＢＣ',250),('2','ＤＥ Ｆ',200),('3','ＧＨＩ',300)
--------------

Query OK, 3 rows affected (0.00 sec)
Records: 3  Duplicates: 0  Warnings: 0

--------------
SELECT * FROM table_coupon_mediumtext
--------------

+-----------+------------+----------+
| coupon_no | memo       | discount |
+-----------+------------+----------+
| 1         | ＡＢＣ     |      250 |
| 2         | ＤＥ Ｆ    |      200 |
| 3         | ＧＨＩ     |      300 |
+-----------+------------+----------+
3 rows in set (0.00 sec)

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

Query OK, 0 rows affected (0.32 sec)

Bye