Question
DXC
DXC
SG
DXC
Posted: Sep 8, 2019
Last activity: Sep 10, 2019
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
Posted: 5 years ago
EvonSys India Pvt Ltd
EvonSys India Pvt Ltd
IN
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
Posted: 5 years ago
PEGA
Pegasystems Inc.
FR
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: 5 years ago
PEGA
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