0 Replies Latest reply: Dec 5, 2012 5:17 AM by 974238 RSS

    wrong curreny symbol

    974238
      Guys,
      We are loading the data from a csv file in oracle table.
      We are using odi procedure which invlokes sqlloader through shell
      script and loads the data.The only issue iam finding is in the file
      we have a record like
      GBP,DEBENHAMS,GREAT BRITAIN POUND STERLING,£,A,,,,
      where you can see pound symbol clearly.
      When we load the data into oracle table
      it will becomes like ¿.
      In the nls_session_parameters table we have like:-
      NLS_CURRENCY £
      NLS_LANGUAGE ENGLISH
      NLS_ISO_CURRENCY UNITED KINGDOM
      NLS_TERRITORY UNITED KINGDOM
      Why it is loading like ¿. ?

      Any ideas?
      Cheers
      Sri