1 Data Types

A data type defines a set of values. A reference to a data type specifies the set of values that can occur in a given context. A data type is associated with each value retrieved from a table or computed in an expression and each constant.

TimesTen follows the ODBC standard for type conversion. For more information, refer to ODBC API reference documentation, which is available from Microsoft or a variety of third parties. The following site contains Microsoft's ODBC API reference documentation:

https://msdn.microsoft.com/en-us/library/ms714562(VS.85).aspx

If you are using TimesTen Cache, see Mappings Between Oracle Database and TimesTen Data Types in Oracle TimesTen In-Memory Database Cache Guide. This section compares valid data types for creating cache group columns and type conversions for passthrough queries.

The following subjects describe data types in TimesTen:

• Type Specifications

• ANSI SQL Data Types

• Types Supported for Backward Compatibility

• Character Data Types

• Numeric Data Types

• BINARY and VARBINARY Data Types

• Numeric Precedence

• LOB Data Types

• ROWID Data Type

• Datetime Data Types

• TimesTen Intervals

• Storage Requirements

• Data Type Comparison Rules

• Data Type Conversion

• Null Values

• INF and NAN

• Overflow and Truncation

• Underflow