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!


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