Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

insert unicode data into nvarchar2 column in a non-unicode DB

776046May 29 2010 — edited May 30 2010

Hi,

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

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 27 2010

Added on May 29 2010

#database-key-features, #globalization-support, #insert, #problem

5 comments

4,205 views