Oracle Audio Technologies B31679-01 manual Data store character set conversion

Data store character set conversion

Beginning with TimesTen 7.0, a character set must be specified for each TimesTen data store using the DSN attribute DatabaseCharacterSet. In some cases, you may need to change the configured data store character set as part of the upgrade process. There are two different cases in which a data store character set conversion will be required:

•You have specified the data store character set as TIMESTEN8 in order to upgrade your data store from a version of TimesTen prior to 7.0 using online upgrade with replication and/or client/server. After the upgrade is complete for all data stores and client applications, you should convert each data store from this special transitional character set to the national character set you prefer to use for your region. See “Converting from the TIMESTEN8 character set” on page 91.

•You need to change your data store’s character set from the one that you originally specified to a new one that fits your requirements more closely. See “Converting from a character set other than TIMESTEN8” on page 92.

Converting from the TIMESTEN8 character set

You may use ttMigrate to convert a data store from TIMESTEN8 to any other character set by completing the following steps:

1.Save the data store to a file using ttMigrate. For example, to save the data store SalesData to the file salesdata.mig, use the command:

ttMigrate -c DSN=SalesData salesdata.mig

2.Destroy the data store: ttDestroy SalesData

3.Change the value of the DSN attribute DatabaseCharacterSet for your data store to the value specifying the new character set. For example, if you want your data store to use the WE8ISO8859P1 character set instead of TIMESTEN8, use the following line in your ODBCINI file:

DatabaseCharacterSet=WE8ISO8859P1

Data Store Upgrades 91