Hi. We are using a custom datatype where we forgot to add the valueType:JSON to our manifest before we got started using it. Now we are getting the value trucated to 500 chars since it is seeing it as string.
We looked at this post
https://our.umbraco.org/forum/umbraco-7/developing-umbraco-7-packages/46784-Changes-to-valueType-not-reflected-in-db#comment167619
but it seems the guy had to physically drop the old datatype and start using a new one.
Is there a way to NOT drop the datatype but recreate/update it? Consider the issue that there is a possibility of lots of data already in use. Dropping the data type will blow away that data based on the warnings when deleting a dataType.
PS: We already tried updating the dbType on the cmsDataType table with no effect.
Update CmsDataType
set dbType = 'Ntext'
where nodeId = 1109
Is it possible to recreate a datatype without losing data
Hi. We are using a custom datatype where we forgot to add the valueType:JSON to our manifest before we got started using it. Now we are getting the value trucated to 500 chars since it is seeing it as string. We looked at this post https://our.umbraco.org/forum/umbraco-7/developing-umbraco-7-packages/46784-Changes-to-valueType-not-reflected-in-db#comment167619 but it seems the guy had to physically drop the old datatype and start using a new one. Is there a way to NOT drop the datatype but recreate/update it? Consider the issue that there is a possibility of lots of data already in use. Dropping the data type will blow away that data based on the warnings when deleting a dataType. PS: We already tried updating the dbType on the cmsDataType table with no effect.
is working on a reply...