Printable View
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!
Have you tried this:
NLS_LANG=GERMAN_GERMANY.WE8ISO8859P1
no, the German character set didn't work.
also my flat file has german and english characters.
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?
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.
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.