1 Reply Latest reply: Nov 5, 2012 2:37 PM by JustinCave RSS

    Character set conversion in oracle

    845109
      Hi All,
      I am having some strange issue while loading a csv file into oracle data base

      csv data is as below :
      æ ªå¼ä¼ç¤¾ã ã¼ãã¼ã¤ã³ãã¯ã,mega

      this should be converted to 株式会社ムービーインパクト,mega while loading into oracle database . I have tried to use NSL_language but didnt work.
      Could someone please help on this .
        • 1. Re: Character set conversion in oracle
          JustinCave
          OK, you have a CSV file. What character set is used to encode that file?
          How are you loading that file into Oracle? Are you using SQL*Loader/ external tables? Or are you using something else?
          What is the data type of the column(s) you are trying to load the data into? CHAR/ VARCHAR2? Or NCHAR/ NVARCHAR2?
          What is the database and national character set of the database?

          Justin