Skip to main content

This content has been archived and is no longer being updated. Links may not function; however, this content may be relevant to outdated versions of the product.

Support Article

Inserts fail with DatabaseException on database character change



After a database character set change from US7ASCII to AL32UTF8, inserts in the PC_LINK_ATTACHMENT table fail with DatabaseException.
However, this works when 'bullet points' in the string are not present.

Error Messages Database-General Problem writing an instance to the database 12899 72000 ORA-12899: value too large for column "PGEPICDATAOWNER"."PC_LINK_ATTACHMENT"."PYMEMO" (actual: 69, maximum: 65)

Steps to Reproduce

Enter bullet points in the free form text of the Notes field and submit the case.

Root Cause

AL32UTF8  is a unicode character set that supports extended symbols, and encodes characters across a variable length of bytes, up to 4.

US7ASCII is a 7-bit character set that fits all of its supported symbols in a single byte with the high bit stripped. Thus it supports half as many characters as WE8ISO8859P1 and does not support most of the special characters.

Therefore, when defining the column by bytes (the default), insertion of a special character whose encoding is changed to an extended encoding, which includes the bullet point, takes up more bytes than it does characters.


Perform the following local-change:

Change the column size definition to characters instead of bytes to support expanded character sets.


Published August 24, 2018 - Updated October 8, 2020

Was this useful?

0% found this useful

Have a question? Get answers now.

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

Did you find this content helpful?

Want to help us improve this content?

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