Loading German characters via SQL Loader
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Loading German characters via SQL Loader

  1. #1
    Join Date
    Apr 2004
    Location
    ny,ny
    Posts
    24

    Loading German characters via SQL Loader

    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:

    Hsker D Husker Du

    thanks!

  2. #2
    Join Date
    Oct 2000
    Location
    Germany
    Posts
    1,185
    Have you tried this:

    NLS_LANG=GERMAN_GERMANY.WE8ISO8859P1
    David Knight
    OCP DBA 8i, 9i, 10g

  3. #3
    Join Date
    Apr 2004
    Location
    ny,ny
    Posts
    24
    no, the German character set didn't work.
    also my flat file has german and english characters.

  4. #4
    Join Date
    Oct 2000
    Location
    Germany
    Posts
    1,185
    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?
    David Knight
    OCP DBA 8i, 9i, 10g

  5. #5
    Join Date
    Apr 2004
    Location
    ny,ny
    Posts
    24
    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.

  6. #6
    Join Date
    Oct 2000
    Location
    Germany
    Posts
    1,185
    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.
    David Knight
    OCP DBA 8i, 9i, 10g

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