1 Reply Latest reply: Jan 10, 2013 11:40 AM by Srini Chavali-Oracle RSS

    Global Language

    903224
      Hi ,

      below is what is there in my file File.csv for a column

      "호텔 주변 교"

      I need to load this into a table, but when i loaded the data using external table
      CREATE TABLE T_EXT
      (C1 VARCHAR2(300 CHAR))
      ORGANIZATION EXTERNAL
      (
      TYPE oracle_loader
      DEFAULT DIRECTORY DIR
      ACCESS PARAMETERS (RECORDS DELIMITED BY NEWLINE
      SKIP 1
      FIELDS TERMINATED BY '|'
      OPTIONALLY ENCLOSED BY '"'
      MISSING FIELD VALUES ARE NULL
      )
      LOCATION ('File.csv'))
      reject limit unlimited


      when i see the data in the table "¿¿ ¿¿ ¿¿¿ ¿¿¿"(inside quotes)

      is it possible to see the same data("호텔 주변 교") in the table , what are changes i need to do to my script ? pls help.