Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 Mohammed Azharuddin Siddavatam (MDAZHARUDDIN)
DXC
Senior Consultant
DXC
SG
MDAZHARUDDIN Member since 2012 14 posts
DXC
Posted: Sep 8, 2019
Last activity: Sep 10, 2019
Posted: 8 Sep 2019 23:24 EDT
Last activity: 10 Sep 2019 14:10 EDT
Closed

Max column length for different properties in blob

Hi All,

For different properties which are stored in blob, is there any maximum limit which the property can hold. Need to know for the below.

1. Integer

2. Text

3. Decimal

4. Datetime

5. Double

To see attachments, please log in.
Data Integration

Posted: 5 years ago
Posted: 9 Sep 2019 0:10 EDT
Venkata Surya Prakash Mallarapu (SuryaMallarapu)
EvonSys India Pvt Ltd
Lead Consultant
EvonSys India Pvt Ltd
AU

Follow the below path

Designer Studio->System->Database->ModifySchema

select any table you wish to check and verify respective size of the properties.

In other way If you have access to database outside of Pega just browse the table and check the schema of PegaDATA

To see attachments, please log in.
Posted: 5 years ago
Posted: 10 Sep 2019 14:10 EDT
Abhinav Gupta (Abhinav7)
PEGA
Manager, Technical Support - Platform Service Engineering
Pegasystems Inc.
IN

Hi,

A BLOB can be 65535 bytes maximum. If you need more consider using a MEDIUMBLOB for 16777215 bytes or a LONGBLOB for 4294967295 bytes.

Thanks,
Abhinav

To see attachments, please log in.

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

Pega Collaboration Center 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