Simon Ye

non-English will become question marks,such as below, one is with N. the other is not. can this be fixed? 

yes.we can not do this with 'sendStringParametersAsUnicode=false' as you said it huge impact on the performance. i will try either of them, is there any impact? #{name,jdbcType=NVARCHAR} #{name,typeHandler=org.apache.ibatis.type.NStringTypeHandler}

how about nvarchar(max)? we have some columns with nvarchar(max).still #{name,jdbcType=NVARCHAR}