-
character set problem in DB link
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|