Support Article

Incorrect character count on a text area

SA-37817

Summary



A Text Area fields fails to commit the entered text sometimes upon submission a associated log error is seen.


Error Messages



'ORA-12899: value too large for column....'


Steps to Reproduce



Not Applicable


Root Cause



A defect or configuration issue in the operating environment.

The Oracle database system was using multi-byte character set (
AL32UTF8) with NLS_LENGTH_SEMANTICS as BYTE.

​So a varchar2(255) column will hold 255 bytes.

In a multi-byte character set some characters (for example, a double quotation mark) would be represented in multiple bytes exceeding the limit of the varchar2 column and resulting the error.

Resolution



Perform the following local-change:

Change the NLS_LENGTH_SEMANTICS to CHAR.
Or,
Use the CHAR keyword when declaring a column length (for example: varchar2(255 CHAR) rather than varchar2(255), which would result in a column that holds 255 characters rather than 255 bytes):

https://pdn.pega.com/support-articles/curly-apostrophe-text-causes-commit-error
https://pdn.pega.com/make-your-applications-oracle-database-ready-internationalization

Published May 11, 2017 - Updated May 26, 2017

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.