Hi,

I want to insert data in multiple languages in SQL server 2005 using hibernate , for that I have changed the data type to nvarchar from varchar. The data being inserted from my application is not getting stored correctly . But it is getting stored correctly when I execute query from SQL server management console and prefix ‘N’ before data (insert into tab values(‘漢語’)), if I don’t then data doesn’t get correctly stored in table.

So question is : does hibernate honors nvarchar and prefix ‘N’ before the data ? if I write custom dialect and map varchar to nvarchar then would hibernate insert data properly ?

Thanks