ORA-12899: value too large for column

Question

I am getting data from erp systems in the form of feeds ,in particular one column length in feed is 15 only.

In target table also corresponded column also length is varchar2(15) but when I am trying to load same into db it showing error like:

ORA-12899: value too large for column emp_name (actual: 16, maximum: 15)

I cant increase the column length since it is base table in the production.

Answer 1

have a look into this blog, the problem resolved for me by changing the column datatype from varchar(100) to varchar(100 char). in my case the data contains some umlaut characters.

http://gerardnico.com/wiki/database/oracle/byte_or_character