My Oracle Support Banner

NLS_LENGTH_SEMANTICS equal CHAR (Doc ID 508787.1)

Last updated on APRIL 30, 2018

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

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
Cause
Solution
 

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.