1. Reference
  2. Connection Attributes
  3. Globalization Connection Attributes
  4. NLS General Connection Attributes
  5. NLS_LENGTH_SEMANTICS

NLS_LENGTH_SEMANTICS

TimesTen uses the NLS_LENGTH_SEMANTICS attribute to set the default length semantics configuration.

Length semantics determines how the length of a character string is determined. The length can be treated as a sequence of characters or a sequence of bytes.

NLS_LENGTH_SEMANTICS can be modified by an ALTER SESSION SQL statement, described in Oracle TimesTen In-Memory Database SQL Reference .

Required Privilege

No privilege is required to change the value of this attribute.

Usage in TimesTen Scaleout and TimesTen Classic

This attribute is supported in both TimesTen Classic and TimesTen Scaleout.

Setting

Set NLS_LENGTH_SEMANTICS as follows:

Where to set the attribute How the attribute is represented Setting

C or Java programs or UNIX and Linux systems odbc.ini file in TimesTen Classic or in the database definition (.dbdef) file in TimesTen Scaleout

NLS_LENGTH_ SEMANTICS

Specify either BYTE (default) or CHAR.

Windows ODBC Data Source Administrator

Not applicable