Defining Data Types


In a data source, a data type is a classification identifying the type of data that determines the possible values or information a field can store - Integer, Numeric, String, and so on. A data type classification also indicates the operations that can be performed on values of that type, and meaning of the data.

Envision supports data types such as Integer, Numeric, String, Date, Clob, Geo-Spatial, Time, and Date & Time. The following table describes the data types of a field in the Dimension pane.

Data Type

Description

Clob Stores unicode character-based data, such as large documents in any character set.
Date Stores year, month, and day values.
Integer Stores whole numerical values (no decimal). Precision 10.
Geo-Spatial Stores GPS latitude and longitude coordinates.
Numeric Stores numerical values with decimals. NUMERIC (p,s) Exact numerical, precision p, scale s. (Same as DECIMAL).
String Stores an alphanumeric string that can contain a maximum of 32,768 characters.
Time Stores hour, minute, and second values.
Date & Time Stores year, month, day, hour, minute, and second values.