![输入图片说明](https://git.oschina.net/uploads/images/2017/0527/151633_3e7d8cc4_403754.png "在这里输入图片标题")
![输入图片说明](https://git.oschina.net/uploads/images/2017/0527/151852_563c21cd_403754.png "在这里输入图片标题")
**sql映射文件**
#sql("insertStore")
INSERT INTO ybh_src_store
select t.id as STOREID,
t.name as SNAME,
t.m_dim1_id as lvlid1,
t.c_area_id as lvlid2,
t.C_DEPART_ID as lvlid3,
decode(t.m_dim1_id, 5776, '品牌一', 5777, '品牌二') as lname1,
a.name as lname2,
b.name as lname3,
SYSDATE as CREATIONDATE,
SYSDATE as MODIFIEDDATE
from C_STORE t, C_AREA a, C_DEPART b
where t.c_area_id = a.id
and t.c_depart_id = b.id
and t.m_dim1_id = 5777
and t.isactive = 'Y'
#end
在数据库里执行
![输入图片说明](https://git.oschina.net/uploads/images/2017/0527/145514_23526576_403754.png "在这里输入图片标题")
结果是正常的
**但是java调用,**
Db.update(StoreList.dao.getSql("insertStore"));
decode(t.m_dim1_id, 5776, '品牌一', 5777, '品牌二') **lname1** 这一列乱码
如图
![输入图片说明](https://git.oschina.net/uploads/images/2017/0527/145909_d2fb9ef0_403754.png "在这里输入图片标题")