character set problem in DB link
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: character set problem in DB link

Hybrid View

  1. #1
    Join Date
    May 2002
    Posts
    22

    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

  2. #2
    Join Date
    May 2005
    Location
    Boracay
    Posts
    681
    try to set both charset to uniform or US7ASCII
    Behind The Success And Failure Of A Man Is A Woman

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width