1. Operations Guide
  2. Globalization Support
  3. Setting Globalization Support Attributes

Setting Globalization Support Attributes

You can set globalization support attributes.

Parameter Description

DatabaseCharacterSet

Indicates the character encoding used by a database.

ConnectionCharacterSet

Determines the character encoding for the connection, which may be different from the database character set.

NLS_SORT

Indicates the collating sequence to use for linguistic comparisons.

NLS_LENGTH_SEMANTICS

Sets the default length semantics.

NLS_NCHAR_CONV_EXCP

Determines whether an error is reported when there is data loss during an implicit or explicit data type conversion between NCHAR/NVARCHAR2 data and CHAR/VARCHAR2 data.

DatabaseCharacterSet must be set during database creation. There is no default. See Choosing a Database Character Set.

The rest of the attributes are set during connection to a database. For more information about ConnectionCharacterSet, see Setting the Connection Character Set.

You can use the ALTER SESSION statement to change the following attributes during a session:

  • NLS_SORT

  • NLS_LENGTH_SEMANTICS

  • NLS_NCHAR_CONV_EXCP

For more information, see ALTER SESSION in the Oracle TimesTen In-Memory Database SQL Reference and Connection Attributes in the Oracle TimesTen In-Memory Database Reference.