Skip to main content

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

Suggest Edit

Published June 1, 2017 - Updated October 8, 2020

Did you find this content helpful?

Have a question? Get answers now.

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

Ready to crush complexity?

Experience the benefits of Pega Community when you log in.

We'd prefer it if you saw us at our best.

Pega Community has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice
Contact us