how to update N data into oracle from mybatis

171 views Asked by At

I am trying to insert/update NCLOB data on oracle using mybatis. But having problem with this.

Data type of column is NCLOB and below is the code i used on sqldeveloper to test it.

UPDATE CONTENT_TABLE SET HTML_DATA = N'通过信息通信系统的整合' WHERE SEQ = 1;

I tried this on sqldeveloper to test it and it works fine.(I put 'N' in front of inserting string for NCLOB. But when i try it by mybatis it does not work... here is the code i tried on mybatis.

UPDATE CONTENT_TABLE SET HTML_DATA = N#{htmlData} WHERE SEQ = 1

That didn't work. Is there any way to use that 'N' to put on NCLOB data in mybatis other ways? (by the way, the reason i used NCLOB data type is to put chinese data on DB.. otherwise when data type was just CLOB, the chinese data that i insert was broken..

0

There are 0 answers