We are planning to store additional user's attributes in Crowd. The max size for the attribute in Crowd right now is only 255 characters. We need to store up to 2000 characters. I updated the DB table and Crowd seems accept the attribute with larger size fine.
alter table cwd_user_attribute modify (attribute_value varchar2(2000));
alter table cwd_user_attribute modify (attribute_lower_value varchar2(2000));
Only a small number of users will have this attribute so I'm not concerning about performance hit. Will this change cause an upgrade issue later on? Are those attributes going to get truncated back to 255 chars.
I believe we will not have problems regarding the column types, however we cannot guarantee that changes in the database model will occur on the newest versions, which can truncate your data. Even though you can perform the customizations, and bear in mind that that some manual procedures will be necessary during the upgrade process to avoid loss of data on those columns.
Hey admins! I’m Dave, Principal Product Manager here at Atlassian working on our cloud platform and security products. Cloud security is a moving target. As you adopt more products, employees consta...
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG
You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs