-------------- 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.00 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 -------------- Query OK, 0 rows affected (0.00 sec) -------------- CREATE TABLE table_coupon ( coupon_no varchar(10) NOT NULL DEFAULT '', memo varchar(30) DEFAULT NULL, discount double DEFAULT NULL ) ENGINE=CONNECT DEFAULT CHARSET=utf8 TABLE_TYPE='MYSQL' TABNAME='table_coupon' DBNAME='test' OPTION_LIST='user=root,host=10.0.1.36' -------------- Query OK, 0 rows affected (0.09 sec) -------------- SELECT * FROM table_coupon -------------- +-----------+------+----------+ | coupon_no | memo | discount | +-----------+------+----------+ | 1 | ??? | 250 | | 2 | ?? ? | 200 | | 3 | ??? | 300 | +-----------+------+----------+ 3 rows in set (0.00 sec) -------------- DROP TABLE table_coupon -------------- Query OK, 0 rows affected (0.00 sec) -------------- CREATE TABLE table_coupon ( coupon_no varchar(10) NOT NULL DEFAULT '', memo varchar(30) DEFAULT NULL, discount double DEFAULT NULL ) ENGINE=CONNECT DEFAULT CHARSET=BINARY TABLE_TYPE='MYSQL' TABNAME='table_coupon' DBNAME='test' OPTION_LIST='user=root,host=10.0.1.36' -------------- Query OK, 0 rows affected (0.06 sec) -------------- SELECT * FROM table_coupon -------------- +-----------+------+----------+ | coupon_no | memo | discount | +-----------+------+----------+ | 1 | ??? | 250 | | 2 | ?? ? | 200 | | 3 | ??? | 300 | +-----------+------+----------+ 3 rows in set (0.00 sec) -------------- DROP TABLE table_coupon -------------- Query OK, 0 rows affected (0.00 sec) -------------- CREATE TABLE table_coupon ( coupon_no varchar(10) NOT NULL DEFAULT '', memo varchar(30) DEFAULT NULL, discount double DEFAULT NULL ) ENGINE=CONNECT DEFAULT CHARSET=utf8 TABLE_TYPE='MYSQL' TABNAME='table_coupon' DBNAME='test' DATA_CHARSET=utf8 OPTION_LIST='user=root,host=10.0.1.36' -------------- Query OK, 0 rows affected (0.04 sec) -------------- SELECT * FROM table_coupon -------------- +-----------+------+----------+ | coupon_no | memo | discount | +-----------+------+----------+ | 1 | ??? | 250 | | 2 | ?? ? | 200 | | 3 | ??? | 300 | +-----------+------+----------+ 3 rows in set (0.00 sec) -------------- DROP TABLE table_coupon -------------- Query OK, 0 rows affected (0.00 sec) -------------- CREATE TABLE table_coupon ( coupon_no varchar(10) NOT NULL DEFAULT '', memo varchar(30) DEFAULT NULL, discount double DEFAULT NULL ) ENGINE=CONNECT DEFAULT CHARSET=binary TABLE_TYPE='MYSQL' TABNAME='table_coupon' DBNAME='test' DATA_CHARSET=utf8 OPTION_LIST='user=root,host=10.0.1.36' -------------- Query OK, 0 rows affected (0.04 sec) -------------- SELECT * FROM table_coupon -------------- +-----------+------+----------+ | coupon_no | memo | discount | +-----------+------+----------+ | 1 | ??? | 250 | | 2 | ?? ? | 200 | | 3 | ??? | 300 | +-----------+------+----------+ 3 rows in set (0.00 sec) Bye