MyBatis Processing of Oracle's char and VARCHAR2

Today, we find a very strange phenomenon, the same SQL statement, in SQL PL can query the results, put into the mybatis under how can not find things. After careful study, the following problems were found:

1. If the field defined in the database is char (20), and the parameter passed in is only 18 bits, in PL/SQL The tool should automatically remove the space or add a space to match;

2, but in MyBatis, there is no such function, using =#{paramname} does not query the results at all.

3, so the solution is: use like ' ${paramname}% ' to process or change the corresponding data field to the VARCHAR2 type.

MyBatis Processing of Oracle's char and VARCHAR2