关于mysql中使用from_base64进行转码的问题

直接看sql把，

SELECT
	t.number AS number,
	n.province AS province,
	n.imsi AS imsi,
	( CASE n.platform WHEN 1 THEN '苹果' WHEN 2 THEN '安卓' WHEN 3 THEN '移动APP' WHEN 4 THEN '拨测' ELSE '未知' END ) AS platform,
	n.OWNER AS OWNER,
	n.creator_name AS creatorName,
	n.create_date AS createDate,
	(
SELECT
	w.keyword 
FROM
	t_blacklist_words d
	INNER JOIN t_blacklist b ON b.blacklist_id = d.blacklist_id
	INNER JOIN t_sensitive_word w ON w.word_id = d.words_id 
WHERE
	b.number = t.number 
	) AS vocabulary
FROM
	t_blacklist t
	INNER JOIN tb_card_number n ON n.number = t.number

查出来是这样的，看下面

我们加上from_base64函数

SELECT
	from_base64 ( t.number ) AS number,
	n.province AS province,
	n.imsi AS imsi,
	( CASE n.platform WHEN 1 THEN '智能拨测' WHEN 2 THEN '用户模拟' WHEN 3 THEN '移动APP测试' WHEN 4 THEN '广东拨测' ELSE '未知' END ) AS platform,
	n.OWNER AS OWNER,
	n.creator_name AS creatorName,
	n.create_date AS createDate,
	(
SELECT
	w.keyword 
FROM
	t_blacklist_words d
	INNER JOIN t_blacklist b ON b.blacklist_id = d.blacklist_id
	INNER JOIN t_sensitive_word w ON w.word_id = d.words_id 
WHERE
	b.number = t.number 
	) AS vocabulary
FROM
	t_blacklist t
	INNER JOIN tb_card_number n ON n.number = t.number

再次查询

然后mysql测试完毕后，转到mybatis就不行了，数据库number类型为BIGINT，复制到mybatis后，number属性值变为了<BLOB>,看下图

找了很久发现了问题，把 from_base64函数修改以下，看下图代码：