Inserting 'ééééé' into a column defined as varchar(5) runs fine from squirrel sql client (jdbc).
But doing the same insert from sqlplus fails with ORA-12899 (too long value).
NLS_CHARACTERSET is set to AL32UTF8
NLS_LENGTH_SEMANTICS is set to CHAR
It look like sqlplus is not honoring these settings…
Where should I look ?
Best Answer
I have the same character set:
Result:
I have
NLS_LENGTH_SEMANTICS
set to BYTE, but I can override this option in this way:My NLS_LANG is:
AMERICAN_AMERICA.UTF8
, because my server is encoded UTF8. But if I unset this environment variable:and if i try again:
so, yo can do a try and set your
NLS_LANG
variable, which is in the formatAnd it would work. You can obtain this parameters from
NLS_DATABASE_PARAMETERS
.