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.
Hi community 👋, as every Monday we're bringing you a quick update on what happened in the Atlassian ecosystem last week. There were a few interesting events like for example the announcement of th...
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events