Programming

I am getting error when loading data file using ctl file. I get this error only when there is special character.
Below is some data.


DataFile=>

company_id|ciu_id|english_name|iso_country_code|active|partner_name
1-2JT-122||Expert Järvenpää|FI|A|Expert Järvenpää

Control File=>
LOAD DATA
CHARACTERSET UTF8
APPEND INTO TABLE MyTable
FIELDS TERMINATED BY '|'
TRAILING NULLCOLS
(
COMPANY_ID,
CIU_ID,
ENGLISH_NAME,
ISO_COUNTRY_CODE,
ACTIVE,
ACTIVE_PARTNER_NAME,
)


Error=>

Record 1: Rejected - Error on table “MyTable”, column ACTIVE.
ORA-12899: value too large for column " MyTable"."ACTIVE" (actual: 25, maximum: 4)

I'd suspect your use of utf-8 and the ä-chars. Try converting the input file to ISO and try it out again...just to see if there's any correlation.