SQL & PL/SQL

Hi,

Our database version = 9.2.0.8.0
NLS_CHARACTERSET = WE8ISO8859P1
NLS_NCHAR_CHARACTERSET = AL16UTF16

We have a table as follows:
CREATE TABLE TAB_UNICODE ( "UNICODE" NVARCHAR2(50), "ENG" VARCHAR2(50 ) )

Now, I want to insert the special character 'Ş' into the "UNICODE" column as follows:

[I am using Oracle SQL developer as apparently Toad and SQL+ does not support unicode.]


Insert into tab_unicode values ('Ş', 'x');

select * from tab_unicod;

UNICODE ENG
¿ x

delete from tab_unicode;

Insert into tab_unicode values (N'Ş', 'x');

select * from tab_unicod;

UNICODE ENG
¿ x

delete from tab_unicode;

NOW, IN THE EXPLORER/BROWSER MODE I POPPED UP THE TABLE AS EDITABLE DATA GRID AND PASTED THE CHARATER 'Ş' under UNICODE column. THEN:

select * from tab_unicod;

UNICODE ENG
'Ş' x

It works then.

MY QUESTION: HOW CAN I INSERT SUCH SPECIAL CHARACTER INTO NCHAR OR NVARCHAR column as INSERT STATEMENT?
Note: I am not using any JDBC/JDK application.

Can anyone please help me.

Regards,
Saby

Edited by: 793420 on Sep 23, 2010 12:17 PM