Oracle Database Discussions

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!

Can't insert data into NVARCHAR2 column

419312Apr 27 2004 — edited May 4 2004

I have a Oracle 8.1.7 database with character set WE8ISO8859P15 and the same for the national character set. I created a table with one column of the VARCHAR2 type and everything worked fine. But when I change the column type to NVARCHAR2 I get various errors: ORA-12704 (when using JDBC), ORA-00911 (when trying to insert euro symbol using Oracle DBA Studio), ORA-00984 (when trying to insert 'abc' using Oracle DBA Studio). Can anyone tell me what is causing these errors??

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 1 2004

Added on Apr 27 2004

#general-database-discussions

11 comments

1,110 views