Carrying Case Owner's Manual

88 Oracle TimesTen In-Memory Database Installation Guide
backward-compatible data types, see “Type specifications” on page 8 in
the Oracle TimesTen In-Memory Database SQL Reference Guide.
Because some of the new Oracle data types have the same names as the
backward-compatible TimesTen data types, a set of aliases has been
added for addressing the data types. Which data types the aliases refer to
depends on the TypeMode that has been set for the data store. See
“TypeMode” on page 20 of the Oracle TimesTen In-Memory Database
API Reference Guide for more information.
TimesTen backward-compatible data types in version 7.0 are
replication-compatible with the data types in versions of TimesTen prior
to 7.0. However, TimesTen backward-compatible data types are not
compatible with TimesTen Cache Connect to Oracle, only the new
Oracle data types can be used with Cache Connect to Oracle. If you
wish to use Cache Connect to Oracle, you must convert any original
TimesTen data types to the new Oracle data types when performing the
data store upgrade with ttMigrate. See “Converting data types to
Oracle data types” on page 90 for details.
Oracle data types are not replication-compatible with versions of
TimesTen prior to 7.0. If you wish to perform an upgrade that requires
replication with a version of TimesTen from before 7.0, you must
upgrade the original data types as TimesTen data types. See “Upgrading
data types as TimesTen data types” on page 90 for more information.
Data store character set
Beginning with TimesTen 7.0, TimesTen requires a data store to be
configured to support a specific character set when it is created. The
character set for the data store is specified using the data store attribute
DatabaseCharacterSet. The value of this attribute is used to determine
which characters may be input to and output from character fields, and
how character data is stored and sorted. See “Choosing a database
character set” on page 74 of the Oracle TimesTen In-Memory Database
Operations Guide for more information.
Before upgrading your data store to TimesTen 7.0, you must specify a
data store character set by adding the DatabaseCharacterSet attribute
to your data store’s DSN. This attribute will be ignored by versions of
TimesTen prior to 7.0. In most cases, you will want to choose a data
store character set that makes sense for your region and that matches the
character data that is already present in your data store. However, there
are three important restrictions you must consider:
• If you plan to use the data store with TimesTen Cache Connect to
Oracle, you must specify a value for DatabaseCharacterSet that is