Oracle Audio Technologies B31679-01 manual Data store character set

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

88Oracle TimesTen In-Memory Database Installation Guide