net.sf.hibernate.dialect
Class OracleIntlDialect

java.lang.Object
  net.sf.hibernate.dialect.Dialect
      net.sf.hibernate.dialect.Oracle9Dialect
          net.sf.hibernate.dialect.OracleIntlDialect

public class OracleIntlDialect
extends net.sf.hibernate.dialect.Oracle9Dialect

A dialect for Oracle 9/10/11, which supports Unicode characters.

Field Summary

Fields inherited from class net.sf.hibernate.dialect.Dialect

CLOSED_QUOTE, QUOTE

Constructor Summary

OracleIntlDialect()
According to http://docs.oracle.com/cd/E11882_01/server.112/e10729/ch7progrunicode.htm#NLSPG336 : The maximum column size allowed is 4000 characters when the national character set is UTF8 and 2000 when it is AL16UTF16.

Method Summary

Methods inherited from class net.sf.hibernate.dialect.Oracle9Dialect

bindLimitParametersInReverseOrder, buildSQLExceptionConverter, getAddColumnString, getCascadeConstraintsString, getCreateSequenceString, getDropSequenceString, getLimitString, getQuerySequencesString, getSequenceNextValString, getViolatedConstraintNameExtracter, supportsForUpdateNowait, supportsForUpdateOf, supportsLimit, supportsSequences, useMaxForLimit

Methods inherited from class net.sf.hibernate.dialect.Dialect

appendIdentitySelectToInsert, bindLimitParametersFirst, closeQuote, createCaseFragment, createOuterJoinFragment, dropConstraints, getAddForeignKeyConstraintString, getAddPrimaryKeyConstraintString, getDefaultProperties, getDialect, getDialect, getDropForeignKeyString, getFunctions, getIdentityColumnString, getIdentityInsertString, getIdentitySelectString, getLimitString, getLowercaseFunction, getNoColumnsInsertString, getNullColumnString, getSchemaSeparator, getTypeName, getTypeName, hasAlterTable, hasDataTypeInIdentityColumn, openQuote, qualifyIndexName, registerColumnType, registerColumnType, registerFunction, supportsCheck, supportsForUpdate, supportsIdentityColumns, supportsIfExistsAfterTableName, supportsIfExistsBeforeTableName, supportsLimitOffset, supportsUnique, supportsUniqueConstraintInCreateAlterTable, supportsVariableLimit, toString

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

Constructor Detail

OracleIntlDialect

public OracleIntlDialect()

According to http://docs.oracle.com/cd/E11882_01/server.112/e10729/ch7progrunicode.htm#NLSPG336 : The maximum column size allowed is 4000 characters when the national character set is UTF8 and 2000 when it is AL16UTF16. The maximum length of an NVARCHAR2 column in bytes is 4000. Both the byte limit and the character limit must be met, so the maximum number of characters that is actually allowed in an NVARCHAR2 column is the number of characters that can be written in 4000 bytes. This means, that you're perfectly able to create column of type NVARCHAR2(2000), but you might not be able to write 2000 characters (rare control characters) there.