My Oracle Support Banner

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

Last updated on AUGUST 04, 2018

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

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


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