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. |
Since Envision does not have a predefined format for the data, different records may contain differently formatted data in the same field. For example, it is possible to find valid dates, integers, and text in one field. The data will therefore, not be formatted, but displayed in its original form. For more information, see Editing Dimensional Values.