Kbase P61212: Contains does not return the correct records with ibm850 database codepage with Version 9.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
18/05/2004 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.1x
SYMPTOM(s):
Contains does not return the correct records with ibm850 database codepage with Version 9.
Contains does not return correct records with non basic collation and ibm850 database codepage.
CAUSE:
The collation rules for the database have not been set correctly for the non basic collation.
FIX:
Create a word break rule file for ibm850 and apply this to the database. The word break file should look like:
/*
*
* NAME: ibm850.wbt
* Word Break Source File for ibm850.
*
*/
version = 9
codepage = ibm850
wordrules-name = basic
type = 3
/* Special word break rules table */
word_attr =
{
91, USE_IT,
92, USE_IT,
93, USE_IT,
94, USE_IT,
95, USE_IT,
96, USE_IT,
129, TERMINATOR,
130, TERMINATOR,
131, TERMINATOR,
132, TERMINATOR,
133, TERMINATOR,
134, USE_IT,
135, TERMINATOR,
136, TERMINATOR,
137, TERMINATOR,
138, TERMINATOR,
139, TERMINATOR,
140, TERMINATOR,
141, TERMINATOR,
142, TERMINATOR,
143, TERMINATOR,
144, TERMINATOR,
145, TERMINATOR,
146, TERMINATOR,
147, TERMINATOR,
148, TERMINATOR,
149, TERMINATOR,
150, TERMINATOR,
151, TERMINATOR,
152, TERMINATOR,
153, TERMINATOR,
154, TERMINATOR,
155, TERMINATOR,
156, TERMINATOR,
157, TERMINATOR,
158, TERMINATOR,
159, TERMINATOR,
160, TERMINATOR,
161, TERMINATOR,
162, TERMINATOR,
163, TERMINATOR,
164, TERMINATOR,
165, TERMINATOR,
181, TERMINATOR,
182, TERMINATOR,
183, TERMINATOR,
184, USE_IT,
185, USE_IT, .
198, TERMINATOR,
199, TERMINATOR
};.