I have a column with type VARCHAR2 (4000 CHAR) and I am testing the size limit of the VARCHAR2 field in Oracle. I thought there was a limit of 4000 bytes
in the field, even specifying the value 4000
in characters, because that error already happened at work and the problem was solved.
When trying to insert a string containing 2000 characters á , an error occurred saying that the value was too large for the field. This happened because the character occupied 2 bytes in the database . However, today the same test was performed and this time the database entered the value correctly.
This occurred on only one of the machines where I work, which has the same configuration as the others.
What can be happening?
Is there any configuration in Oracle that might be allowing you to insert a string with more than 4000 bytes?