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!

Problem reading nchar data from oracle database

613820Apr 30 2009 — edited May 1 2009

I have an oracle database which nls character set is set to ALS32UTF8 and nls nchar character set is set to UTF8.

But however if i insert any data to a nvarchar column in a table.

Subsequent when i do a select the data i got is ???.

Why is this so?

The funny thing is that using TOAD i can read view the correct nvarchar data using the schema brower - > data

But if i use sql to do a select i get ???.

Any idea anyone and how to resolve this?

Locked Post

New comments cannot be posted to this locked post.

Locked on May 29 2009

Added on Apr 30 2009

#general-database-discussions

3 comments

661 views