O'Reilly logo

Umbraco User's Guide by Paul Sterling, Nik Wahlberg

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

THE DATA TYPE'S PURPOSE

What is a data type in the realm of Umbraco? In short, it's an interface for editors to use to manipulate, save, and publish data for any given document type field in Umbraco. In technical terms, it's an input type used to store data in a particular format. Umbraco allows you to store this data in four predefined database data type formats. Table D-1 lists the supported database data types.

Table D-1: Supported Database Data Types

DATA TYPE DESCRIPTION
Date Use this data type for date and time stamp, such as event start date and so on.
Integer Use this data type if you are recording the number of available spots for an event or to store a node ID, for example. Only numbers are allowed when using this data type.
Ntext In terms of size, Ntext is the most flexible but also the data type that will take up the most space in your database. Any number of characters can be stored in this data type. The suggested use is for the Richtext Editor or other large input field.
Nvarchar This data type is most useful for simple text strings because it grows with the number of characters as needed, up to a maximum of 500 characters.

image One critical thing to keep in mind is that when you create an Umbraco data type and specify, for example, Integer, and then decide to change it to Nvarchar at a later time, the data that was stored in the Integer field will not ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required