topic Re: Oracle ORA-01401 when comparing long NVARCHAR2 columns with certain NLS settings in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/oracle-ora-01401-when-comparing-long-nvarchar2-columns-with/m-p/235476#M188606 <HTML><HEAD></HEAD><BODY><SPAN>Just a small correction: removing the trigger won't fully correct the issue, as the default </SPAN><CODE>NLS_SORT</CODE><SPAN> is set from </SPAN><CODE>NLS_LANGUAGE</CODE><SPAN>, and sorts don't work if it's anything but </SPAN><CODE>'BINARY'</CODE><SPAN>. Removing the trigger does fix comparisons clauses though.</SPAN><BR /></BODY></HTML> Wed, 21 Sep 2016 13:46:09 GMT matej1 2016-09-21T13:46:09Z Oracle ORA-01401 when comparing long NVARCHAR2 columns with certain NLS settings https://connect.hyland.com/t5/alfresco-archive/oracle-ora-01401-when-comparing-long-nvarchar2-columns-with/m-p/235475#M188605 Hello everyone,we're getting errors for queries to our Oracle Express database version 11.2.0.2.0.An example:### Error querying database. Cause: java.sql.SQLDataException: ORA-01401: inserted value too large for column ### The error may exist in org/activiti/db/mapping/entity/HistoricProcessInstance Wed, 21 Sep 2016 13:38:12 GMT https://connect.hyland.com/t5/alfresco-archive/oracle-ora-01401-when-comparing-long-nvarchar2-columns-with/m-p/235475#M188605 matej1 2016-09-21T13:38:12Z Re: Oracle ORA-01401 when comparing long NVARCHAR2 columns with certain NLS settings https://connect.hyland.com/t5/alfresco-archive/oracle-ora-01401-when-comparing-long-nvarchar2-columns-with/m-p/235476#M188606 <HTML><HEAD></HEAD><BODY><SPAN>Just a small correction: removing the trigger won't fully correct the issue, as the default </SPAN><CODE>NLS_SORT</CODE><SPAN> is set from </SPAN><CODE>NLS_LANGUAGE</CODE><SPAN>, and sorts don't work if it's anything but </SPAN><CODE>'BINARY'</CODE><SPAN>. Removing the trigger does fix comparisons clauses though.</SPAN><BR /></BODY></HTML> Wed, 21 Sep 2016 13:46:09 GMT https://connect.hyland.com/t5/alfresco-archive/oracle-ora-01401-when-comparing-long-nvarchar2-columns-with/m-p/235476#M188606 matej1 2016-09-21T13:46:09Z Re: Oracle ORA-01401 when comparing long NVARCHAR2 columns with certain NLS settings https://connect.hyland.com/t5/alfresco-archive/oracle-ora-01401-when-comparing-long-nvarchar2-columns-with/m-p/235477#M188607 <HTML><HEAD></HEAD><BODY><SPAN>Oh, another possible solution would be to convert all </SPAN><CODE>NVARCHAR2</CODE><SPAN> columns to </SPAN><CODE>VARCHAR2</CODE><SPAN>, and is the solution I'm currently leaning towards.</SPAN><BR /><BR /><SPAN>By browsing StackOverflow I got the impression that </SPAN><CODE>NVARCHAR2</CODE><SPAN> is more of a legacy feature for non Unicode databases.</SPAN><BR /></BODY></HTML> Wed, 21 Sep 2016 15:43:07 GMT https://connect.hyland.com/t5/alfresco-archive/oracle-ora-01401-when-comparing-long-nvarchar2-columns-with/m-p/235477#M188607 matej1 2016-09-21T15:43:07Z