Data Type

Specify a data type:

• datetime - 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 nvarchar 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.