DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2001

    Charecter set problem

    Export done at solaris server, I am trying to import in same version but in Windows 2000 server.

    it is given charcter set problem. can i change charcter set, I an not able to find out NLS_charcterset parameter in init.ora file.

    can anyone suggest

    Import: Release - Production on Thu Dec 19 20:41:00 2002

    (c) Copyright 2000 Oracle Corporation. All rights reserved.

    Connected to: Oracle8i Enterprise Edition Release - Production
    With the Partitioning option
    JServer Release - Production

    Import file: EXPDAT.DMP > E:\Saco\algo.dmp

    Enter insert buffer size (minimum is 8192) 30720>

    Export file created by EXPORT:V08.01.07 via conventional path
    import done in WE8ISO8859P1 character set and WE8ISO8859P1 NCHAR character set
    export server uses WE8ISO8859P15 NCHAR character set (possible ncharset conversi

  2. #2
    Join Date
    Dec 2002
    Granite City , Illinois

    Charater Set

    Anuj ,

    The character set is initially set in the "Create Database" statement,before doing an export make sure your OS env variable for NLS_LANG, you can use the following script to find what character set is set for your database:

    select 'export NLS_LANG="'||char_date.value||'_'
    from v$nls_parameters char_date,
    (select value
    from v$nls_parameters
    where parameter='NLS_ISO_CURRENCY') char_iso_value,
    (select value
    from v$nls_parameters
    where parameter = 'NLS_CHARACTERSET') char_char_value
    where char_date.parameter = 'NLS_DATE_LANGUAGE';

    ALSO NOTE: In order to change Character Set you have to RECREATE DB!!

  3. #3
    Join Date
    Jun 2000
    Madrid, Spain
    WE8ISO8859P15 is WE8ISO8859P1 but supports EURO sign, thatīs just a warning, if you want to avoid it then set your NLS_LANG to WE8ISO8859P1

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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.