ORA-12899, while actual value length is smaller than maximum

1
votes

I've loaded some data using SQL*Loader and obtained following strange error messages:

ORA-12899: value too large for column AELS_AENDBESCHR (actual: 69, maximum: 70)

ORA-12899: value too large for column AELS_AENDBESCHR (actual: 70, maximum: 70)

Actually the values don't exceed the maximum, so what the hell these messages are doing here then?

1
oracleora-12899
Multi-byte charecters may be? - Rajesh Chamarthi
Possibly related to stackoverflow.com/q/11979495/409172 It might help if you post the control file, table DDL, and the actual data. - Jon Heller

1 Answers

0
votes

Indeed, the problem was in the character set of the database. I tried to put data supposed for 1 byte character set in a database with UTF-8 encoding, where german symbols "äöü" take 2 bytes instead one. I changed the character set using this wikibooks and now it works. The only problem is that I can't use APEX after it.