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)