如何查询unhex值

[lost_guy_in_scut]

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表示出来。

[rucypli]

select c,bin(c) from t;

[lost_guy_in_scut]

引用 1 楼 rucypli 的回复:

select c,bin(c) from t;

大神，不行呀。