Changing a code page

You can change the code page in a schema image at any time. The Create DataServer Schema utility allows you to create a schema image even if you do not have the correct code-page information. You can add or correct the code-page information at a later date. However, if you have been writing 8-bit character data to your Oracle database with the DataServer, that data is unaffected by the change in the code page. Your database might be corrupted if you start writing data with the DataServer and a schema image that uses a new code page.

To change the DataServer code page:

  1. Choose DataServer > ORACLE Utilities > Change DataServer Schema Code Page. The following message appears:


  2. Choose OK to continue. The following dialog box appears:


  3. Type the OpenEdge name for the code page that the Oracle Database uses.
    Note:

    See Internationalize ABL Applications for a complete list of code pages that OpenEdge supports. If you are using an unsupported code page, OpenEdge allows you to create your own conversion tables.

  4. Choose OK to change the code page and return to the Data Administration main window.
    If you were connected to the schema holder and Oracle database when you chose to change the code page, the utility disconnected you to make the change. The Connect Database dialog box appears to allow you to reconnect.