1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

oracle 8i export to oracle 12c chinese character issue

Discussion in 'General' started by manu890, Dec 12, 2014.

  1. manu890

    manu890 Guest

    Hi, All

    I will be very appreciate if someone can give me some hints. I have been testing several days to find out the issue of display Chinese character problem.


    Export server Oracle version (Unix machine)

    Oracle8i Enterprise Edition Release 8.1.7.0.0

    select DECODE(parameter, 'NLS_CHARACTERSET', 'CHARACTER SET',
    'NLS_LANGUAGE', 'LANGUAGE',
    'NLS_TERRITORY', 'TERRITORY') name,
    value from v$nls_parameters
    WHERE parameter IN ( 'NLS_CHARACTERSET', 'NLS_LANGUAGE', 'NLS_TERRITORY')

    Name Value
    language american
    territory american
    character US7ASCII


    set nls_lang=american_america.us7ascii in my machine

    I can display traditional chinese character in sqlplus properly



    exp userAdm/pwd01@sampleDB FULL=Y FILE=sampleDB.dmp

    export successfully
    ---------------------------------------------



    Import server Oracle version
    Oracle Database 12c release 12.1.0.1.0 64bit

    I create a new db on the import server (Windows 7)

    Name Value
    language american
    territory american
    character ZNT16MSWIN95


    set nls_lang=american_america.us7ascii before import

    imp userAdm/pwd01@sampleDB file=sampleDB.dmp log=sampleDB.log full=y

    import successfully

    However, when I set nls_lang=american_america.us7ascii in my machine

    I CANNOT display traditional chinese character in sqlplus properly

    Also tried following language, still in vain

    set nls_lang=TRADITIONAL CHINESE_TAIWAN.ZHT16MSWIN950
    set nls_lang=AMERICAN_AMERICA.AL16UTF16
    set nls_lang=american_america.ZHT16MSWIN950

    Can anyone give me some hints?
    Thanks!