Data store character set – Oracle Audio Technologies B31679-01 User Manual
Page 96
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
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
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