I have a custom data set with a number of custom fields set as alphanumeric text fields - it's become clear that some of these would be better as note/text areas.
Because I'm increasing the size of the fields, rather than decreasing them and potentially cutting off existing data, I'm hoping it's possible to change them in the database.
From what I can see, the only tables affected are civicrm_custom_field (where I'd be changing data_type and html_type) and the civicrm_value_custom_data_set (where I'd be changing the relevant field's Type from varchar to text and removing the 255 character limit).
There's only a small amount of data entered using the custom data set, but I'd rather not have to re-enter everything (particularly as it means deleting and recreating the custom fields as well as the data).
Is this possible? Is there anywhere else I need to change the settings? Or is this just generally a horrible idea?