Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Mac McDell 73 posts 148 karma points
    May 31, 2016 @ 16:55
    Mac McDell
    0

    How to recreate Datatype?

    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
    
Please Sign in or register to post replies

Write your reply to:

Draft