Why Does SQL Developer Show Incorrect Value For NLS_LENGTH_SEMANTICS (Doc ID 1055797.1)

Last updated on OCTOBER 27, 2016

Applies to:

Oracle SQL Developer - Version 1.5.4 to 4.0
Information in this document applies to any platform.
***Checked for relevance on 07-Nov-2014***

Goal


Having a database which has been configured to use NLS_LENGTH_SEMANTICS = CHAR.

When using Enterprise Manager or SQL*Plus the following statement correctly shows the database is using CHAR semantics:

select * from NLS_SESSION_PARAMETERS where PARAMETER='NLS_LENGTH_SEMANTICS';
PARAMETER VALUE
---------------------------------------------------------------- ------
NLS_LENGTH_SEMANTICS CHAR

Using SQL Developer the same statement will display BYTE as the value.

Solution

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