We are facing a scenario where data type of view keeps on changing from MediumText and Text depending upon the the data getting hold in view column.
This causes any issue whenever data store is published and CDT column definition does not match the View Column definition.
Discussion posts and replies are publicly visible
How is your view defined? Similar issues can occur say if your view is defined with "*" such as "SELECT * FROM TABLE_XYZ", where as the view should be defined with columns specifically identified as "SELECT column1, column2, column3 FROM TABLE XYZ". Utilizing "*" in your view will also require the view to be republished if columns are added to the table later on. Just one thought on the issue there.
I generally use a cast for my fields in the view for this case. Cast it to a specific CHAR length and then it will not change.
Hope that helps!
Thank you Chris and Christine. Yes, we have now applied cast function to such columns and it seems to be working fine.