@ColumnTransformer(read = "CAST(unseal_text(sMemberId) AS CHAR CHARACTER SET UTF8)", write = "seal_text(CAST(? AS CHAR CHARACTER SET UTF8))")
private String memberId;

       CAST(unseal_text(order0_.sMemberId) AS order0_.CHAR order0_.CHARACTER order0_.SET order0_.UTF8) as column8_0_0_,

public class HibernateSecurityInterceptor extends EmptyInterceptor {

   private static final long serialVersionUID = 7049750866908874951L;

   @Override
   public String onPrepareStatement(String sql) {
      // Cast string
      String insertCastStart="CAST(";
      String insertCastEnd=" AS CHAR CHARACTER SET UTF8)";

      Pattern p = Pattern.compile("(?i:unseal_text)");
      Matcher m = p.matcher(sql);

      // find cast point
      List<Integer> castStartPoint = new ArrayList<Integer>();
      while(m.find()){
         castStartPoint.add(m.start());
      }

      // insert increase sql string lenth.
      int offset=0;
      StringBuffer sb = new StringBuffer(sql);
      for(Integer point : castStartPoint){
         sb.insert(point+offset, insertCastStart);
         sb.insert(sb.indexOf(")", point+offset)+1,insertCastEnd);
         offset += insertCastStart.length();
         offset += insertCastEnd.length();
      }

      return super.onPrepareStatement(sb.toString());
   }
}