hibernate: MS-SQL Server and UTF-8

[mars1412]

How can I tell MS-SQL Server to create columns as nvarchar() instead of varchar()?
in MS-SQL Server the varchar() columnd do not support UTF-8 characters!

[mars1412]

found the answer:

you have to create your own hibernate dialect and then set the correct column types:

package mypackage;

import java.sql.Types;

public class SQLServerDialect extends
org.hibernate.dialect.SQLServerDialect {

 public SQLServerDialect() {
 super();
 registerColumnType(Types.CHAR, "nchar(1)" );
 registerColumnType(Types.VARCHAR, "nvarchar($l)" );
 }

}

then use this dialect in your persistence.xml file:


see also http://forum.hibernate.org/viewtopic.php?t=972518&highlight=sql+server+nvarchar