Data types
When creating a new attribute, you will need to select the data type. This determines the format of data stored in the attribute.
Review the available data types below.
Character data types
String: Data displayed as characters, such as the First Name attribute. This data type allows values up to 500 characters in length.
Text: Data displayed as characters, such as URL. This data type allows values up to 8,000 characters in length.
Number data types
Data type | Bytes | Range (signed) | Range (unsigned) |
---|---|---|---|
Integer (int) | 4 | -2,147,483,648 to 2,147,483,647 | 0 to 4,294,967,295 |
Big integer (bigint) | 8 | -9,223,372,036,854,775,808 to 9,223,372,036,854,775,807 | 0 to 18,446,744,073,709,551,615 |
Small integer (smallint) | 2 | -32,768 to 32,767 | 0 to 65,535 |
Tiny integer (tinyint) | 1 | -128 to 127 | 0 to 255 |
Decimal: Displays data as numeric values with a defined set of numbers to the right of the decimal.
Float: Displays data as approximate numeric values and is a single-precision 32-bit IEEE 754 floating point. Should not be used for precise values, such as currency.
Double: Displays data as approximate numeric values and is a double-precision 64-bit IEEE 754 floating point. Should not be used for precise values, such as currency.
Date and time data types
Date: Displays Date values.
Timestamp: Displays data as a combination of Date and Time values.
Note: If no time zone is specified in timestamp data, then Oracle Unity will assume that the time zone being used for incoming data is Coordinated Universal Time (UTC). You have the option to use a timestamp format with a specific time zone (yyyy-MM-dd HH:mm:ss z). Learn more about date and time format standards.
The following formats are supported for displaying date and timestamp data:
-
yyyyMMdd
-
dd-MM-yyyy
-
yyyy-MM-dd
-
MM/dd/yyyy
-
yyyy/MM/dd
-
dd MMM yyyy
-
dd MMMM yyyy
-
yyyyMMddHHmm
-
yyyyMMdd HHmm
-
dd-MM-yyyy HH:mm
-
yyyy-MM-dd HH:mm
-
MM/dd/yyyy HH:mm
-
yyyy/MM/dd HH:mm
-
dd MMM yyyy HH:mm
-
dd MMMM yyyy HH:mm
-
yyyyMMddHHmmss
-
yyyyMMdd HHmmss
-
dd-MM-yyyy HH:mm:ss
-
yyyy-MM-dd HH:mm:ss
-
MM/dd/yyyy HH:mm:ss
-
yyyy/MM/dd HH:mm:ss
-
dd MMM yyyy HH:mm:ss
-
dd MMMM yyyy HH:mm:ss
Other data types
Boolean: Data displayed as one of two values, True or False.
Array - string: A collection of values that all have the String data type. Using this data type will limit data ingest transformations to Lookup/static.
Managing the Oracle Unity data model