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

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 ...

Get Umbraco User's Guide now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.