Skip to Main Content

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!

select unicode values from unicode database in nonunicode database

Rati ToduaMar 4 2016 — edited Mar 9 2016

hello. i apologies if i am posting it in wrong place. here's my question:

as title says, i have 2 database. one is unicode and other is not. so i want to enter in non-unicode database and select tables from unicode database with db_link. and i want it to return unicode characters. here's what i found out

this is my unicode database, with different types of columns:

select_from_unicode_db.png

and this is my select with db_link from non_unicode database:

select_from_nonunicode_db.png

as you can see it only allows me to see columns which's types are nchar and nvarchar2;

my question is what must be done so i could see other types of columns too, like char, varchar2 etc...

This post has been answered by Sergiusz Wolicki-Oracle on Mar 4 2016
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 6 2016
Added on Mar 4 2016
4 comments
2,784 views