Copied to clipboard

Flag this post as spam?

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


  • Tobias Larm 5 posts 95 karma points
    Jul 19, 2017 @ 08:12
    Tobias Larm
    0

    Textstring vs Textarea - maxlength

    Hi,

    What's the maximum length for Textstring- vs Textareaproperty when saving content to the database?

  • Jeffrey Schoemaker 408 posts 2138 karma points MVP 8x c-trib
    Jul 20, 2017 @ 13:02
    Jeffrey Schoemaker
    101

    Hi Tobias,

    and welcome to Our!

    The difference between the Textstring and the Textarea is that the first one is stored in the datanvarchar-column in the table cmsPropertyData, and the TextArea is stored in the datantext-column.

    The datanvarchar column is (a bit dependent on your exact Umbraco-version) normally 500 characters long.

    The datantext column is a ntext column and according to Microsofts documentation superlong (https://docs.microsoft.com/en-us/sql/t-sql/data-types/ntext-text-and-image-transact-sql).

    Hope this answers your question,

    Jeffrey

  • Tobias Larm 5 posts 95 karma points
    Jul 20, 2017 @ 13:13
    Tobias Larm
    0

    Hi Jeffrey,

    And thank you for your response! That answered my question, yes. :)

  • 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