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

Question

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?

Possibly related to http://stackoverflow.com/q/11979495/409172 It might help if you post the control file, table DDL, and the actual data. — Jon Heller, Sep 12 '12 at 18:36

Liebster Kamerad · Accepted Answer · 2012-09-17T08:38:25.707

0

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.

edited Sep 17 '12 at 08:38

answered Sep 17 '12 at 07:32

Liebster Kamerad

6,179
2
19
18

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

1 Answers1

Linked