I am facing some issues inserting Korean characters into one of our table. our table has both Varchar and Nvarchar columns to handle national language characters. And the table already contains some Korean characters in one of the nvarchar column, now I am trying to inserting some rows with some Korean characters in the same column , but I am unable to .
if I am running below query, output is inverted question marks
select N'愚者可浹旬而學' as test from dual
I don't think its a client issue, because if I am connected to a different database , same query returns Korean characters. so it has to be database
And the database's NLS are bleow
NLS_NCHAR_CHARACTERSET AL16UTF16
NLS_CHARACTERSET WE8ISO8859P15
So as per my understanding NVarchar columns should be supporting Korean characters, but how do I go about writing insert scripts with national characters.