CREATE TABLE t (a CHAR(8) DEFAULT REVERSE('aha')) CHARACTER SET utf32;

--echo # In MTR

SHOW CREATE TABLE t;

--echo # In the command line client

--exec $MYSQL test -e "SHOW CREATE TABLE t"

--echo # In mysqldump

--exec $MYSQL_DUMP test > $MYSQL_TMP_DIR/1.dump

--cat_file $MYSQL_TMP_DIR/1.dump

DROP TABLE t;

# In the command line client

Table	Create Table

t	CREATE TABLE `t` (\n  `a` char(8) DEFAULT \0\0\0r\0\0\0e\0\0\0v\0\0\0e\0\0\0r\0\0\0s\0\0\0e('aha')\n) ENGINE=MyISAM DEFAULT CHARSET=utf32 COLLATE=utf32_general_ci

# In mysqldump

...

CREATE TABLE `t` (

  `a` char(8) DEFAULT ;

/*!40101 SET character_set_client = @saved_cs_client */;