Hibernate (HQL) query is not working properly if column (NVARCHAR datatype) data contains japanese character. It does not return any result after comparing japanese data.
After Prefixing literal unicode strings with 'N' plain JDBC query works fine, but HQL query gives org.hibernate.hql.ast.QuerySyntaxException: unexpected token: '日本語'
Environment:
Hibernate version : 3.6.10 Database : MSSQL Server 2005