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

How to store large data in a single value property

SA-5577

Summary



Large XML must be stored in data table under a single value property without parsing it. This data table is mapped to a table in the database. Can the data type be changed to Character Large Object (CLOB) to store large XML?

Resolution



CLOB is not supported by Pega Platform.
 
Store it in Binary Large Object (BLOB) using an unoptimized property.
Or
Store it as an attachment, which will again go into the BLOB.

If the text size of the exposed column exceeds 4000 characters, the data up to 4000 characters would be stored with an additional + symbol. The + symbol indicates that some of the information has been truncated.
 
Suggest Edit

Published August 1, 2016 - Updated October 8, 2020

Did you find this content helpful? Yes No

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.

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