title: SQL*Loader does not recognize delimiter "¥"
body: <p>When trying to load an UTF-8 file with <strong>¥</strong> separator, it doesn't separate the fields when it finds the character. We get an ORA-12899 error from the value exceeding the column size, since it tries to put the entire line into the first column.</p>
  
  <p>In UTF-8 , <strong>¥</strong> is <strong>Â¥</strong> ( C2A5), but it seems that it is trying to find C2C2A5.</p>
  
  <p>The database settings are</p>
  
  <pre><code>NLS_LANGUAGE    SPANISH
  NLS_TERRITORY   SPAIN
  NLS_CURRENCY    ?
  NLS_ISO_CURRENCY    SPAIN
  NLS_NUMERIC_CHARACTERS  ,.
  NLS_CHARACTERSET    WE8ISO8859P15
  NLS_CALENDAR    GREGORIAN
  NLS_DATE_FORMAT DD/MM/RR
  NLS_DATE_LANGUAGE   SPANISH
  NLS_SORT    SPANISH
  NLS_TIME_FORMAT HH24:MI:SSXFF
  NLS_TIMESTAMP_FORMAT    DD/MM/RR HH24:MI:SSXFF
  NLS_TIME_TZ_FORMAT  HH24:MI:SSXFF TZR
  NLS_TIMESTAMP_TZ_FORMAT DD/MM/RR HH24:MI:SSXFF TZR
  NLS_DUAL_CURRENCY   ?
  NLS_COMP    BINARY
  NLS_LENGTH_SEMANTICS    BYTE
  NLS_NCHAR_CONV_EXCP FALSE
  NLS_NCHAR_CHARACTERSET  AL16UTF16
  NLS_RDBMS_VERSION   11.2.0.3.0
  </code></pre>
  
  <p>We have tried with:</p>
  
  <pre><code>NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1
  NLS_LANG=SPANISH_SPAIN.WE8MSWIN1252
  </code></pre>
  
  <p>We are running SQL*Loader from a command window on Windows 7 machine with Spanish locale.</p>
  
  <p>Control file:</p>
  
  <pre><code>LOAD DATA
  CHARACTERSET UTF8
  INFILE  'C:\tmp\xxxy.txt'
  BADFILE 'C:\tmp\xxxy.bad'
  TRUNCATE INTO TABLE  SAMPLE.TEST_CAR_VENCIMI_INTERMED
  fields terminated by "¥"
  TRAILING NULLCOLS
  (
  CODE             CHAR "upper(ltrim(rtrim(:CODE)))",
  CIF              CHAR "upper(ltrim(rtrim(:CIF)))",
  CODIGO_PRESTAMO  CHAR "upper(ltrim(rtrim(:CODIGO_PRESTAMO)))"
  )
  </code></pre>
  
  <p>Sample data file:</p>
  
  <pre><code>21AK0100¥P11111111F¥910002¥000000000106013.64¥666666666¥mail@domain.com¥address¥11111¥Name¥Surname 1¥Surname 2¥mail2@domain.com¥666666666
  </code></pre>