Progress
Internationalization Guide


Using Unicode With Progress Applications

Creating and running an application that uses Unicode is not difficult. Here is an example of creating and running an application consisting of a database server, a graphical client, and a UTF–8 database.

Since UTF–8 is supported by the Progress database server but not by the Progress graphical or character client:

To create the application:

  1. Convert the database to Unicode using one of the techniques in the "Using Unicode With Progress Databases" section.
  2. Design queries that access only records that use client’s code page.
  3. One way to do this is for tables to have a field that indicates the record’s code page. When records are added, the field is populated. When the database is queried, the query references the code page field in order to return only those records in the client’s code page.

    Imagine that in the Sports database, the Customer table has a field, db-language, indicating the code page or language of the record. A client whose language corresponds to the value of the variable user-language might submit a query similar to the following:

    FOR EACH customer WHERE db-language = user-language:
      DISPLAY name address city country comments.
    END. 
    

  4. Start a Progress database server, setting the server’s code page to UTF–8.
  5. The following command fragment illustrates this:

    proserve -cpinternal utf-8 -cpstream ... 
    

  6. Start a client in the native code page (perhaps ISO8859–15). Set -cpinternal, -cpstream, and the other code-page-related startup parameters to this code page.
  7. The following command illustrates this:

    prowin32 -cpinternal iso8859-15 -cpstream iso8859-15 
    

Your Unicode application is up and running.


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095