Question
4
Replies
129
Views
NCS
Posted: 1 year ago
Last activity: 1 year ago
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
Posted: 1 year ago
Posted: 1 year ago
I want the max length for the properties which are stored in blob and not for the properties which are exposed.
Posted: 1 year ago
Hello,
It depends how your properties have been configured. If you have specify a max length or not. If not, I don't think you will be limited.
Posted: 1 year ago
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
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