Appendix B Language Support

Language support

In many languages, each letter and number can be represented by a single-byte character set. Each character is represented by an 8 bit byte. At most, 256 characters can be represented.

For many languages such as Japanese or Taiwanese 256 characters is not sufficient. In cases such as these, a double-byte character set is necessary to represent the large number of characters that make up the language. In a few languages even double-byte character sets are not sufficient, in which case a multi-byte character set is used.

Multi-byte characters and PowerDynamo
PowerDynamo supports multi-byte character sets up to 4 bytes in length.

Collation Sequence

Each character set has its own collation sequence (sorting order) for characters in a character set. The collation sequence is important when doing queries and compares such as:

<!--SQL
SELECT emp_lname, emp_fname
from EMPLOYEE
where emp_lname > 'S'
-->

The collation sequence enables the database to determine if J is greater than or less than S in this example.

One language is supported per Dynamo Web Server
The first site you connect to through a Web server sets the collation sequence for all PowerDynamo Web sites on that server. All subsequent databases being connected to must use the same collation sequence.

Adaptive Server Anywhere language support

The collation sequence used by an Adaptive Server Anywhere database is selected when the database is created. If no collation sequence is specified, a default collation sequence is used.

The collation sequence used by the PowerDynamo scripting engine is specified in the host database. If no collation sequence was specified for the database at the time of creation, the collation sequence from the PowerDynamo language DLL is used.

The Japanese language DLL (dys03jpt.dll) sets the collation sequence to sjis (Japanese Shift-JIS Encoding).

The English language DLL (dys03ent.dll) sets the collation sequence to cp437, ASCII, United States .

To change the collation sequence used by PowerDynamo, create a new database and specify the appropriate collation sequence for the required language. Store the PowerDynamo Web site in the newly created database. The Web site will have the same collation sequence as that specified for the new database.

Individual collation sequence
PowerDynamo and Adaptive Server Anywhere have individual collation sequences. They are not necessarily the same.

For more information about collation sequences, see the Sybase Adaptive Server Anywhere User's Guide.

Adaptive Server Enterprise language support

The character set used by an Adaptive Server Enterprise server is set when it is created. If no collation sequence is specified, the default collation sequence is used.

The character set used by the PowerDynamo scripting engine is determined by the character set specified in the host server. PowerDynamo reads the character set from the Enterprise server and then maps it to the appropriate PowerDynamo character set by means of the table shown here.

Dynamic file site language support

For a dynamic file site to use a collation sequence other than the default, you must specify a character set in the registry:

1. From your system's Registry Editor, open the following file:
   HKEY_LOCAL_MACHINE\SOFTWARE\Sybase\PowerDynamo
   
2. Create a new string value called Character Set with a string value of the desired character set, for example "cp437".
   The following string values are valid:
   
   
   • "cp437"
   • "cp850"
   • "cp852"
   • "cp855"
   • "cp855"
   • "cp860"
   • "cp866"
   • "cp869"
   • "eucb5"
   • "eyecup"
   • "eucjis"
   • "eucksc"
   • "iso_1"
   • "sjis"
   • "utf8"
   
   
3. Restart the Web server.

Copyright © 1999 Sybase, Inc. All rights reserved.