We had a problem last week in our project environments, which is related to database.
Some persistent operation (Same text insertion ) working on SIT db and the same is not working on UAT db :
So did checked the difference and found that their character set used is different.
This results in different length check for same input text.
The problem happened with VARCHAR column type and the UI for particular field is a free text element.
Executed the following query in both the environment to get some information on character sets.
SELECT * FROM NLS_DATABASE_Parameters WHERE parameter = 'NLS_CHARACTERSET';
SELECT * FROM NLS_DATABASE_Parameters WHERE parameter = 'NLS_NCHAR_CHARACTERSET';
Found the following information regarding that :
NLS_CHARACTERSET is used for CHAR, VARCHAR2, CLOB, columns and NLS_NCHAR_CHARACTERSET used for NCHAR, NVARCHAR2, NCLOB columns.
The output of the above queries matters on low level encoding of column values in the DB.
