I have been scouring the internet but I can't seem to find the answer that I require about hibernate and its support for unicode.

I currently have a hibernate mapping file and I use hbm2ddl to generate the DDL for the mapping file.

What settings do I need to force hbm2dll to generate my "string" columns as "nvarchar" instead of varchar?

Thanks for any help!

Hi,

The key thing you need to know about here is that Hibernate will be generating the DDL statements based on what it knows about the particular RDBMS that you are using. That is configured through a Dialect.

A Google search showed up the following blog post:

http://blog.cherouvim.com/sql-server-hbm2ddl-unicode-columns/

which describes exactly what you have asked about.

Basically you:
- create a subclass of the Dialect for the RDBMS that you are using and make it override the existing default data type mappings
- specify your new class as hibernate.dialect in your Hibernate configuration


--
Stephen Souness




blog: http://elegant-solutions.blogspot.com/