Data Type Support
Certain Oracle Database data types are not supported by TimesTen.
TIMESTAMP WITH TIME ZONE
TIMESTAMP WITH LOCAL TIME ZONE
INTERVAL YEAR TO MONTH
INTERVAL DAY TO SECOND
UROWID
BFILE
- Oracle Database-supplied types
- User-defined types
The following TimesTen data types are not supported by Oracle Database:
TT_CHAR
TT_VARCHAR
TT_NCHAR
TT_NVARCHAR
TT_BINARY
TT_VARBINARY
TINYINT
andTT_TINYINT
TT_SMALLINT
TT_INTEGER
TT_BIGINT
TT_DECIMAL
TT_DATE
TIME
andTT_TIME
TT_TIMESTAMP
Note:
TimesTen NCHAR
and NVARCHAR2
data
types are encoded as UTF-16. Oracle Database NCHAR
and
NVARCHAR2
data types are encoded as either UTF-16 or UTF-8.
To cache an Oracle Database NCHAR
or
NVARCHAR2
column, the Oracle Database
NLS_NCHAR_CHARACTERSET
encoding must be AL16UTF16
,
not AL32UTF8
.