/mcpDescription Null Option Default MS SQL Server Data Type Unified ICM and Unified CCE Defined Data Type A date and time accurate to the second. Stored as two four-byte integers (eight bytes total): days before or since January 1, 1900 and seconds since midnight. datetime datetime DBDATETIME A four-byte floating-point value (7-digit precision). NULL real DBFLT4 An eight-byte floating-point value (15-digit precision). float float DBFLT8 A date and time accurate to the minute. Stored as two unsigned two-byte integers (four bytes total): number of days since January 1, 1900 and minutes since midnight. smalldatetime smalldatetime DBSMALLDATE A four-byte integer value between -2,147,483,648 and 2,147,483,647. NULL int DBINT A two-byte integer value between -32,768 and 32,767. NULL smallint DBSMALLINT Up to 255 characters. The value 255 is the storage size. NULL varchar(255) DESCRIPTION A one-byte integer value between 0 and 255. NOT NULL tinyint DBTINYINT Up to 10 characters. The value 10 is the storage size. NULL char (10) TELNO Up to 32 characters. The value 32 is the storage size. varchar(32) varchar(32) VNAME32 Up to 10 characters. The value 10 is the storage size. NULL varchar(10) VTELNO10 Up to 20 characters. The value 20 is the storage size. NULL varchar(20) VTELNO20 Up to n characters. The value n is the storage size. NULL char(n) char(n) Up to n characters. The value n is the storage size. NULL varchar(n) varchar(n) Up to 2,147,483,647 bytes of binary data. The storage size is determined by the length of the data. NULL image image A date and time accurate to the second. Stored as two four-byte integers (eight bytes total): days before or since January 1, 1900 and seconds since midnight. NULL datetime datetime A date and time accurate to the minute. Stored as two unsigned two-byte integers (four bytes total): number of days since January 1, 1900 and minutes since midnight. NULL smalldatetime smalldatetime Database Schema Handbook for Cisco Unified Contact Center Enterprise, Release 15.0(1) 5 Introduction Data Types