Lost 'umlaute' during import to 8.1.7 under Linux

From: Kurt-Erich Finger <kurt-erich.finger_at_hte-company.de>
Date: 7 May 2003 05:31:03 -0700
Message-ID: <5208be2f.0305070431.7d9572f@posting.google.com>

Hello,

we migrated a 8.1.7 database from NT to Suse Linux Enterprise Server 7 via the export - import route.
The tablespaces (on Linux) were generated using a script that was also used to migrate from one machine to another (it worked under NT).

Now we miss these notorious special German characters (umlaute).

The export log says:
Export done in WE8ISO8859P1 character set and WE8ISO8859P1 NCHAR character set

The new database was created with

CREATE DATABASE ORCL
LOGFILE 'D:\Redologs\redo01.log' SIZE 50M,

'D:\RedoLogs\redo02.log' SIZE 50M,
'D:\RedoLogs\redo03.log' SIZE 50M

MAXLOGFILES 32
MAXLOGMEMBERS 3
MAXLOGHISTORY 3
DATAFILE 'D:\ORACLEDBF\sys1.dbf' SIZE 100M AUTOEXTEND ON NEXT 10M MAXDATAFILES 254
MAXINSTANCES 3
CHARACTER SET WE8ISO8859P1
NATIONAL CHARACTER SET WE8ISO8859P1; What did we missed?
Do we have to set NLS_LANG to GERMAN_DIN_GERMANY.WE8ISO8859P1 before creating the database?

thanks,

Kurt-Erich Received on Wed May 07 2003 - 07:31:03 CDT