Database characterset Issue.
SQL> SELECT * FROM NLS_DATABASE_PARAMETERS WHERE PARAMETER LIKE '%CHARACTERSET';
PARAMETER VALUE
------------------------------ ----------------------------------------
NLS_NCHAR_CHARACTERSET AL16UTF16
NLS_CHARACTERSET WE8MSWIN1252
MY DATABASE IS CREATED WITH ALL ABOVE NCHAR_CHARACTERSET AND CHARACTERSET
We choose WESTERN EUROPEAN CHARACTERSET ( Initially we are ingesting only european langauges) .
we are trying to ingest some arabic character now using NVARCHAR2 .
If Im using linux machine everything seems working perfectly. but the data is not displaying properly on windows. (not sure if I need to install something on window).
SQL> DESC TEST
NAME NULL? TYPE
------------------- -------- -----------------------------------------------------------
A NVARCHAR2(255)
B NUMBER
If I trying to insert from windows, it gets broken