1.2. National Character Types
National Character types, which is a new feature since JDBC 4.0 API, now available in hibernate type system.
National Language Support enables you retrieve data or insert data into a database in any character
set that the underlying database supports.
Depending on your environment, you might want to set the configuration option hibernate.use_nationalized_character_data
to true and having all string or clob based attributes having this national character support automatically.
There is nothing else to be changed, and you don't have to use any hibernate specific mapping, so it is portable
( though the national character support feature is not required and may not work on other JPA provider impl ).
The other way of using this feature is having the @Nationalized
annotation on the attribute
that should be nationalized. This only works on string based
attributes, including string, char, char array and clob.
@Entity( name="NationalizedEntity")
public static class NationalizedEntity {
@Id
private Integer id;
@Nationalized
private String nvarcharAtt;
@Lob
@Nationalized
private String materializedNclobAtt;
@Lob
@Nationalized
private NClob nclobAtt;
@Nationalized
private Character ncharacterAtt;
@Nationalized
private Character[] ncharArrAtt;
@Type(type = "ntext")
private String nlongvarcharcharAtt;
}
Table 1.2. National Character Type Mappings
Hibernate typeDatabase typeJDBC typeType registry
org.hibernate.type.StringNVarcharType
string
NVARCHAR
nstring
org.hibernate.type.NTextType
string
LONGNVARCHAR
materialized_clob
org.hibernate.type.NClobType
java.sql.NClob
NCLOB
nclob
org.hibernate.type.MaterializedNClobType
string
NCLOB
materialized_nclob
org.hibernate.type.PrimitiveCharacterArrayNClobType
char[]
NCHAR
char[]
org.hibernate.type.CharacterNCharType
java.lang.Character
NCHAR
ncharacter
org.hibernate.type.CharacterArrayNClobType
java.lang.Character[]
NCLOB
Character[], java.lang.Character[]