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.