I have two databases
DB1 :-
NLS_NCHAR_CHARACTERSET=AL16UTF16
NLS_CHARACTERSET=WE8MSWIN1252
DB2:-
NLS_CHARACTERSET=US7ASCII
NLS_NCHAR_CHARACTERSET=US7ASCII
I created a DB link to DB2 from DB1
Using sqlplus, I logged in the DB1 database from DB1 machine , I executed the query
SELECT state from country@TO_DB2;
C?CERES
Then I logged into the DB2 database from DB1 machine, I executed the query
SELECT state from country
CACERES
Why the character A is replaced by some junk value? I want to use the DB link to access the DB2 database, How to solve this issue?
Thanks in Advance
Kumar