Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Special character shows as question mark after insert

Ranganathan VenkatesanDec 8 2015 — edited Dec 8 2015

Hi Folks,

I am trying to do a below steps to insert a special character for a column.

create table Test

( text VARCHAR2(500) )

insert into Test(text) values ('Администрация');

select text from test;

Result of above is

?????????????

select dump(text,1016) from Test;

Result of above is

Typ=1 Len=13 CharacterSet=AL32UTF8: 3f,3f,3f,3f,3f,3f,3f,3f,3f,3f,3f,3f,3f

NLS_CHARACTERSET is AL32UTF8

Oracle Version is 11.2.0.3

We already have some tables with varchar2 tables having values of this kind. If we try to insert record from those tables then its working fine. but only when we try to do in Insert Script by providing values it is showing Question Mark symbol

Please help to fix this.

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 5 2016

Added on Dec 8 2015

#database-key-features, #globalization-support

9 comments

11,849 views