Hi,
I have table with a field with type NVARCHAR2.
While trying to insert data into this field from PL/SQL developer, it store the value as inverted question mark (?).
If I copy paste the multilingual data in the field, it store as it is & when I query, I can view the data. Its while inserting, I'm facing this issue.
Oracle is 11g
NLS_NCHAR_CHARACTERSET = AL16UTF16
NLS_CHARACTERSET = WE8MSWIN1252
NLS_LANGUAGE = ENGLISH
What could be the issue & where am I going wrong.
Thanks in advance,
RAJ
I have table with a field with type NVARCHAR2.
While trying to insert data into this field from PL/SQL developer, it store the value as inverted question mark (?).
If I copy paste the multilingual data in the field, it store as it is & when I query, I can view the data. Its while inserting, I'm facing this issue.
Oracle is 11g
NLS_NCHAR_CHARACTERSET = AL16UTF16
NLS_CHARACTERSET = WE8MSWIN1252
NLS_LANGUAGE = ENGLISH
What could be the issue & where am I going wrong.
Thanks in advance,
RAJ