insert unicode data into nvarchar2 column in a non-unicode DB
776046May 29 2010 — edited May 30 2010Hi,
I'm using oracle 10.2.0.1 with we8iso8859p8 characterset and utf8 for nchar characterset.
I have a table with a nvarchar2 column in which i want to store unicode data.
I want to use Sql Developer to insert data into the nvarchar2 column.
I'm able to write the unicode string in Sql Developer but all i get in the nvarchar2 column is '?' chars.
I've read the different forums discussing this issue, I understand there is some OCI_ATTR_CHARSET_FORM parameter that can help me by setting it to
SQLCS_NCHAR, but I don't understand how i can change it without reprogramming the OCI.
Can someone help issue the problem?
Thanks,
Alex