Loading German characters via SQL Loader

[challsql]

1) a sample of the datafile

Hüsker Dü^A|Husker Du

2) I have set NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1.
when loaded to a table the data looks like this:



Hüsker Dü^A Husker Du


3)would like data to look like the following:

Hüsker Dü Husker Du

thanks!

[dknight]

Have you tried this:

NLS_LANG=GERMAN_GERMANY.WE8ISO8859P1

[challsql]

no, the German character set didn't work.
also my flat file has german and english characters.

[dknight]

did you receive an error when you tried the German character set?

could you display it?

are there English characters that do not appear in German?

[challsql]

i received no erors...

the data was just loaded unchanged(with the strange characters):



Hüsker Dü^A Husker Du

yes there are english characters that don't appear in German as they should.

basically, i want to be able to load english and german alphabets.

[dknight]

if you do not load the 'ü', it will not be generated from the 'ü' .

German characters are a superset of English characters as far as i know.