The following table lists the database field data types supported by Content Manager OnDemand.
Field Type |
Description |
Field Size (DB2) |
Field Size (Oracle) |
Field Size (SQL Server) |
---|---|---|---|---|
Small Int |
Contains whole numbers between -32768 and 32,767. |
2 bytes |
21 bytes |
2 bytes |
Integer |
Contains whole numbers between -2147483648 and 2147483647. |
4 bytes |
21 bytes |
4 bytes |
Big Int |
Contains whole numbers between -9223372036854775808 and 9223372036854775807. |
8 bytes |
21 bytes |
8 bytes |
Decimal |
Contains numbers between 10(307) and 10(308) with up to 15 significant digits. |
8 bytes |
21 bytes |
8 bytes |
DecFloat (16) |
Decimal floating-point number with 16 digits of precision. |
8 bytes |
Not available |
Not available |
DecFloat (34) |
Decimal floating-point number with 34 digits of precision. |
16 bytes |
Not available |
Not available |
String (Fixed) |
Contains letters, numbers, special symbols, such as the % and #, and any other printable character. |
1 - 254 bytes.
|
1 - 254 bytes.
|
1 - 254 bytes.
|
String (Variable) |
Contains letters, numbers, special symbols, such as the % and #, and any other printable character. |
1 - 2000 bytes.
|
1 - 2000 bytes.
|
1 - 2000 bytes.
|
Date | Contains a valid date from January 1, 0001 to December 31, 9999. | 4 bytes | 7 bytes | 3 bytes |
Date (old style) |
Contains a valid date from January 1, 1970 to September 17, 2059. |
2 bytes | 2 bytes | 2 bytes |
Time (old style) |
Contains times of day, stored in three second increments, since midnight, and limited to 24 hours. |
2 bytes | 2 bytes | 2 bytes |
Date/Time | Contains a valid date from January 1, 0001 to December 31, 9999. | 13 bytes | 11 bytes | 8 bytes |
Date/Time (old style) |
Contains both a date and time value. The date can be from January 1, 1970 to January 18, 2038. The time is stored in one second increments. |
4 bytes | 4 bytes | 4 bytes |
Date/Time (TZ) | Contains a valid date from January 1, 0001 to December 31, 9999. | 13 bytes | 11 bytes | 8 bytes |
Date/Time (TZ) (old style) |
Contains both a date and time value. A Date/Time (TZ) field is exactly like a Date/Time field, but uses the time zone from the client. |
4 bytes | 4 bytes | 4 bytes |
The Date, Date/Time, and Date/Time (TZ) field types introduced in Content Manager OnDemand Version 9.0 are not compatible with clients from previous releases. If you must retain compatibility with clients from previous releases, use the Date (old style), Date/Time (old style), and Date/Time (TZ) (old style) field types.
Starting with Content Manager OnDemand Version 9.0, you cannot add a Time (old style) field to an application group.