Re: How can i convert from USASCII7 to WE8ISO8859P1 ?

Hello Doug,

  the ALTER DATABASE CHARACTER SET statement really did the job. It appears, the umlauts our customer had in his database were in fact iso-characters. Just that the database "thought" it contained only US7ASCII characters. After altering the old database I was able to export the data correctly as WE8ISO8859P1 and reimport it into the new database.

  Just for the sake of completeness, here is what I did:

1. Start the old database in exclusive mode and alter the character set: (according to the "Oracle8i National Language Support Guide")

$ svrmgrl system/<passwd of system>

    SVRMGR> SHUTDOWN IMMEDIATE
    SVRMGR> STARTUP MOUNT
    SVRMGR> ALTER SYSTEM ENABLE RESTRICTED SESSION;
    SVRMGR> ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;
    SVRMGR> ALTER DATABASE OPEN;
    SVRMGR> ALTER DATABASE CHARACTER SET WE8ISO8859P1;
    SVRMGR> SHUTDOWN IMMEDIATE
    SVRMGR> STARTUP
    SVRMGR> QUIT

  2. Set the NLS_LANG parameter and do the export:     

$ NLS_LANG=GERMAN_GERMANY.WE8ISO8859P1
$ export NLS_LANG
$ exp system/<passwd of system>

  3. ftp the expdat.dmp file to the new system, set NLS_LANG

     and do the import.

Thank you so much!

        Ulrich Received on Wed Jun 21 2000 - 00:00:00 CDT