如何查询unhex值

Question

show create table t;
+-------+-------------------------------------------------------------------------------------+
| Table | Create Table                                                                        |
+-------+-------------------------------------------------------------------------------------+
| t     | CREATE TABLE `t` (
  `c` binary(30) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 |
+-------+-------------------------------------------------------------------------------------+insert into t set c=hex('juhua');
Query OK, 1 row affected select c,unhex(c) from t;
+--------------------------------+----------+
| c                              | unhex(c) |
+--------------------------------+----------+
| {114锛?24}
| 616263
| 6A75687561
| NULL                           | NULL     |
+--------------------------------+----------+请教如何将数据库字段c的值，unhex表示出来。

Answer 1

select c,bin(c) from t;