SQLDeveloper Incorrectly Displaying Some Characters Only for CLOB Datatype with Database Character Set WE8ISO8859P15

(Doc ID 2336843.1)

Last updated on DECEMBER 07, 2017

Applies to:

Oracle SQL Developer - Version 17.3.1 and later
Information in this document applies to any platform.

Symptoms

The following behavior is only seen when SQLDeveloper is connected to a 12.2.0.1 database with NLS_CHARACTER_SET set to WE8ISO8859P15. (Other DB character sets like GEO8BOGALTWIN are also affected)

create table test (col_a VARCHAR2(25), col_b CLOB); 

insert into test values ('atenção','CAMPEÂO'); 

Select * from test;

COL_A                     COL_B                                                                            
------------------------- -------------
atenção                   CAMPE?O  

 

If SQLDeveloper is connected to a 11.2.0.4 with same NLS_CHARACTER_SET, there is no problem.

COL_A                         COL_B
------------------------- ---------------
atenção                       CAMPEÂO


The issue does not happen from SQLPLUS connected to a 12.2.0.1.0 database.

If using NCLOB data type instead of CLOB, the issue is not displayed.

If SQLDeveloper is configured with an Oracle Client using Thick driver, the issue is not displayed.

The issue only happens when there is a thin JDBC connection with 12.2.0.1 database version.

 

Cause

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