Copied to clipboard

Flag this post as spam?

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


  • Pete 152 posts 176 karma points
    Nov 03, 2009 @ 16:36
    Pete
    0

    ntext vs. nvarchar

    What are the differences with these two?

     

    At the moment I'm finding that content.getproperty on instances of datatypes using ntext return an empty string while I can actually see the data in the XML, e.g. <data alias="doctypeXXX"><![CDATA[11173,11324,11168,11181,11178]]></data> returns nothing while a datatype set to nvarchar looks like this: <data alias="doctypeXXX">11173,11324,11168,11181,11178</data> and returns 11173,11324,11168,11181,11178.

    Do I need to do something differently in the getProperty call to access ntext types?

  • Masood Afzal 176 posts 522 karma points
    Nov 03, 2009 @ 17:08
    Masood Afzal
    0

    Have you published the page again after making these changes?

     

  • Pete 152 posts 176 karma points
    Nov 03, 2009 @ 17:38
    Pete
    0

    I found the problem:

    When the render control or its settings are changed from something using ntext to something using nvarchar, the values are not copied, merely over-written on next publish. A db query on affected cmspropertydata rows that updates the nvarchar value with the ntext value fixes this. 

  • This forum is in read-only mode while we transition to the new forum.

    You can continue this topic on the new forum by tapping the "Continue discussion" link below.

Please Sign in or register to post replies