We have a property of integer type but now a requirement came like it can accept characters as well but in prod we have instances of the property having int value how to resolve this
You have to drop the column and recreate as varchar backend. But keep in mind to have a backup. Otherwise ask Pega GCS to alter the table type to varchar, but backup is necessary. If the old data is lost, you need you own logic to restore them.