Hi All,

I am facing one problem. My application database is sql server 2005, and I am using hibernate mapping.

Recently we modified on table to support Japanese characters to nvarchar from varchar.
Data is getting stored and retrieve correctly.

The problem is when we executes select query with where clause like, from table_name where column_name='data_in_japanese' this query fails to read Japanese data stored in table.

I know, we can pull information by using prefixing data 'N' like column_name=N'data' in plain-sql, but how that will get append in HQL?

OR

In-other words, what should be java data-type I should mention in mapping xml for nvarchar db-type? I tried with java.lang.String but its not working for me.

Can anyone please suggest solution for this?