Question
4
Replies
175
Views
NCS
Posted: September 8, 2019
Last activity: September 10, 2019
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
Moderation Team has archived post,
Close popover
This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.
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