NLS_LENGTH_SEMANTICS equal CHAR
Last updated on MARCH 02, 2017
Applies to:Siebel System Software - Version 7.8.2  and later
z*OBSOLETE: Microsoft Windows Server 2003
Product Release: V7 (Enterprise)
Version: 7.8.2 
Database: Oracle 18.104.22.168
Application Server OS: Microsoft Windows 2003 Server SP1
Database Server OS: Sun Solaris 9
This document was previously published as Siebel SR 38-3070010111.
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms