Using installutil to set the data code page value for a pre-7.0 schema repository

After you use the codepageutil utility to evaluate an existing database set and convert any unsupported characters, you can use the installutil utility to set its Rational® ClearQuest® data code page value.

Before you begin

You must perform the following steps before you can set your data code page value:

Disconnect all Rational ClearQuest clients from the schema repository and user databases. If you do not, connected clients can still enter data outside the new code page after you set the Rational ClearQuest data code page value, .
Back up the schema repository and all user databases.

About this task

Starting with ClearQuest version 7.0, the standard method for setting the Rational ClearQuest data code page for a new schema repository or connection is to use the Maintenance Tool. However, you can also use the installutil utility to set the data code page value.

The commands in this example use MyDBset as the name of the database set.

Procedure

From a Windows system, run the installutil lscodepage command to determine the local character set of your operating system and the data code page for your schema repository.
```
installutil lscodepage -dbset MyDBset admin_user admin_password
```
```
Code page of MyDBset: 932 (Japanese (Shift-JIS))  
Code page of client: 1252 (MS Windows Latin 1)
```
In this example, the local character set is 1252 (MS Windows Latin 1. The Rational ClearQuest data code page value of the MyDBset schema repository is currently set to 932 (Japanese (Shift-JIS)).
Then, run the installutil setdbcodepage subcommand to set the Rational ClearQuest data code page to the preferred value. For a list of code pages supported by Rational ClearQuest, see Supported data code pages
installutil setdbcodepage -dbset MyDBset 1252 admin_user admin_password

Results

The data code page for your schema repository is now set and any user databases you create inherit this data code page setting.