My Oracle Support Banner

NLS_LENGTH_SEMANTICS equal CHAR (Doc ID 508787.1)

Last updated on FEBRUARY 11, 2024

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




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.

 

 

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
 

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.