You can start a database server in two ways:

  • By invoking PROSERVE from a command line or from an OpenEdge client
  • By using OpenEdge Explorer or OpenEdge Management , a graphical application

When an OpenEdge client invokes PROSERVE, PROSERVE starts a database server on behalf of the client. For a ABL client, PROSERVE starts a ABL database server. For an SQL client, PROSERVE starts an SQL database server.

If a client invokes PROSERVE with startup parameters, such as -cpinternal, -cpstream, and -cpcoll, PROSERVE passes these values to the ABL or SQL database server. The ABL database server uses these values. The SQL database server, however, ignores some of these values. Specifically, the SQL database server ignores values for -cpinternal and -cpcoll passed from PROSERVE, using instead the internal code page and collation table of the database. However, the SQL database server does use the values for -cpstream and for the other code-page-related startup parameters (other than -cpinternal and -cpcoll) passed from PROSERVE.

When you start a database server using OpenEdge Explorer or OpenEdge Management you can specify a code page and a collation by using the Explorer's administrative features.

The following table lists localizable startup parameters and settings for SQL and ABL database servers.

Table 1. Localizable startup parameters and settings
Command line startup parameters Command line startup parameter defaults Progress Explorer settings Progress Explorer setting defaults 
-cpinternal
 ISO8859-1 Code page (internal) ISO8859-1 
-cpstream
 IBM850 NA IBM850 
-cplog
 IBM850 Log character set ISO8859-1 
-cpcase
 BASIC Case table BASIC 
-cpcoll
 BASIC Collation table BASIC 
-convmap
 OpenEdge/convmap.cp Conversion map OpenEdge/convmap.cp

OpenEdge Explorer and OpenEdge Management also let you set the log file's font. This allows you to choose a font that displays international characters correctly.

To set the log file's font:

  1. From OpenEdge Explorer or OpenEdge Management, view a log file.
  2. From the Action menu, select Font.... Alternatively, click on the toolbar Font icon. The standard Windows Font Selection dialog box appears.
  3. In the Font Selection dialog box, choose a font, then click OK. OpenEdge Explorer or OpenEdge Management displays the log file using the font you selected.