Question
DXC
SG
Last activity: 10 Sep 2019 14:10 EDT
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
Datacom Group
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
DXC
SG
I want the max length for the properties which are stored in blob and not for the properties which are exposed.
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.
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