MariaDB [test]> create table t (a binary default '');
|
Query OK, 0 rows affected (0.044 sec)
|
|
MariaDB [test]> set names sjis;
|
Query OK, 0 rows affected (0.000 sec)
|
|
MariaDB [test]> show create table t;
|
+-------+-------------------------------------------------------------------------------------------------------------------+
|
| Table | Create Table |
|
+-------+-------------------------------------------------------------------------------------------------------------------+
|
| t | CREATE TABLE `t` (
|
`a` binary(1) DEFAULT '�_0'
|
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci |
|
+-------+-------------------------------------------------------------------------------------------------------------------+
|
1 row in set (0.000 sec)
|
|
MariaDB [test]> set names utf8;
|
Query OK, 0 rows affected (0.000 sec)
|
|
MariaDB [test]> show create table t;
|
+-------+------------------------------------------------------------------------------------------------------------------+
|
| Table | Create Table |
|
+-------+------------------------------------------------------------------------------------------------------------------+
|
| t | CREATE TABLE `t` (
|
`a` binary(1) DEFAULT '\0'
|
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci |
|
+-------+------------------------------------------------------------------------------------------------------------------+
|
1 row in set (0.001 sec)
|