This discussion is archived
1 Reply Latest reply: Jan 10, 2013 9:40 AM by Srini Chavali-Oracle RSS

Global Language

903224 Newbie
Currently Being Moderated
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.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points