hbm2ddl default to unicode types

oztigertim · **Posted:** Sun Mar 25, 2007 7:01 pm

Hibernate version: 3.2

Name and version of the database you are using: SQL Server 2000, Oracle 10g

Hi all,

I'm trying to get the hbm2ddl tool to generate unicode types such as nvarchar by default not varchar.

Is this possible?

Or is the only option to go through all my annotated beans and set the sql-type?

Cheers,
Tim

max · **Posted:** Mon Mar 26, 2007 5:18 am

you can tweak a subclass of your dialect to use a different type that the defaults.

oztigertim · **Posted:** Tue Mar 27, 2007 10:34 pm

Thanks Max.

For anyone else trying to do this I just needed these two lines..

Code:

   registerColumnType( Types.CHAR, "nchar(1)" );
   registerColumnType( Types.VARCHAR, "nvarchar($l)" );

[/code]