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.

Learn more

Managing the Oracle Unity data model

Attributes

Data objects

data types, attributes, array, string, boolean, date, timestamp, integer, tiny integer, small integer, big integer, float, double, decimal