Progress
Internationalization Guide
Collation Tables
A collation table tells Progress how to sort or compare characters. Progress uses a collation table when it:
- Compares CHARACTER strings using a 4GL relational operator or the 4GL COMPARE function
- Computes the collation value of a CHARACTER data item using the 4GL COLLATE option of the FOR statement, the OPEN QUERY statement, and the PRESELECT phrase
- Sorts the results of a 4GL query that uses the FOR statement’s BY or EACH option
- Sorts the results of an SQL-89 query that uses the SELECT statement’s ORDER BY option
- Builds or rebuilds databases indexes
Figure 3–3 shows code page 1253’s GREEK collation table, which resides in the
greek.dat
file.
Figure 3–3: Code Page 1253’s GREEK Collation Table
Figure 3–3 shows that the collation table has two sections, one for case-insensitive sorts and one for case-sensitive sorts. Each section has a value for each element in the code page. The value of an element represents the sort order of that element. For example, in a case-insensitive sort that uses this collation table, element 1 sorts first and element 97 sorts sixty-sixth.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |