Kbase P20849: What is the functionality of a collation table?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
17/02/2006 |
|
Status: Verified
GOAL:
What is the functionality of a collation table?
GOAL:
What is a collation table?
GOAL:
How does Progress perform EQ or = compares?
GOAL:
What does Progress use a collation table for?
GOAL:
What is the default collation table used by Progress?
FIX:
A collation table tells Progress how to sort or compare characters. It is a table that maps a character set to an alternative collating sequence that changes the sort order of 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
The default collation table used is basic.
Depending on the collation table that Progress is using, a normal character and an accented character may actually be considered equals.
As an example, capital A and capital A-accent are considered to be equal in the basic collation table because they have the same weight.