Consultor Eletrônico

Status: Unverified

SYMPTOM(s):

4GL/ABL: Query fails to return some records using Canadian French data.

The query fails to retrieve records involving accented upper case French Canadian letters.

Session is using the -cpcase French startup parameter.

FACT(s) (Environment):

All Supported Operating Systems
Progress 9.x
OpenEdge 10.x

CAUSE:

The Session's -cpcase French startup parameter is appropriate for use with the French French language because the accented lower case letters loose their accents when capitalized. The Session's -cpcase French startup parameter is NOT appropriate for use with the Canadian French language because the accented lower case letters retain their accents when capitalized. Thus, records involving accented capital letters will be missed if the query search condition is looking for them and the session's -cpcase is set to French.

FIX:

Set the session's -cpcase startup parameter to BASIC. In other words, use the -cpcase BASIC in your startup command or .pf file.