Data Type

Select a data type:

datetime Specifies the date and time.
decimal Fixed precision and scale numeric data from -10^38+1 through 10^38-1.
int Integers -2^31 (-2,147,483,648) through 2^31 - 1 (2,147,483,647).
smallint Integers -2^15 (-32,768) through 2^15 - 1 (32,767).
tinyint Integers 0 through 255.
money Monetary data values from -2^63 (-922,337,203,685,477.5808) through 2^63 - 1 (+922,337,203,685,477.5807), with accuracy to a ten-thousandth of a monetary unit.

Storage is 8 bytes.

nchar Fixed-length Unicode data, with a maximum length of 4,000 characters.
nvarchar Precision value for this is the range 1-4000 or the value MAX.
uniqueidentifier A value is initialized by the SQL NEWID function or by converting from a string constant. A string constant is in the form xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx, where each x is a hexadecimal digit in the range 0-9 or a-f.
varbinary Precision value is the range 1-8000 or the value MAX.

On the UET User Fields form, select a data type for the user field. On other UET forms, the data type you selected on the UET User Fields form displays.