NLS_LENGTH_SEMANTICS equal CHAR (Doc ID 508787.1)

Last updated on MARCH 02, 2017

Applies to:

Siebel System Software - Version 7.8.2 [19213] and later
z*OBSOLETE: Microsoft Windows Server 2003
Product Release: V7 (Enterprise)
Version: 7.8.2 [19213]
Database: Oracle 9.2.0.7
Application Server OS: Microsoft Windows 2003 Server SP1
Database Server OS: Sun Solaris 9

This document was previously published as Siebel SR 38-3070010111.


Symptoms

We are using Siebel 7.8 and Oracle 10.1.0.5 and our DB is Unicode AL32UTF8.
We have a question about the NLS_LENGTH_SEMANTICS parameter.
By default, NLS_LENGTH_SEMANTICS is set to BYTES.

What value should we set the NLS_LENGTH_SEMANTICS parameter to for Siebel SIA and Analytics applications? Can that be Bytes or Char?

We want have some multi-byte characters in our Oracle DB either by users entering the data manually or by loading them through Analytics.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms