Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003
    Location
    Nuernberg, Germany
    Posts
    36

    Unanswered: German Umlaut '','' .. from ORACLE to MS SQL

    Hi,

    I fetch data from a SAP-Oracle-database into SQL via DTS-package.

    Customernames, Streetnames, .....

    will result in |
    in _
    and so on.

    looks like a common problem.

    thanx for any help

    Mike

  2. #2
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    I would search for some code page comparison guide. You will probably have to modify the DTS package to read from the Oracle instance with a particular collation or code page. Having never had to do this, I am not sure if DTS can automagically translate between the two different code pages.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •