Kbase P114203: Multiple component characters are not compared correctly when performing a comparison within a query
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
23/03/2006 |
|
Status: Unverified
FACT(s) (Environment):
OpenEdge 10.0x
SYMPTOM(s):
Multiple component characters are not compared correctly when performing a comparison within a query
The ü character and ue multiple component character are not treated equally when running a query
The multiple component characters are compared correctly when an index is used to resolve the query
The multiple component characters are compared correctly when connected to the database in single-user mode
Using an ICU collation for the -cpcoll parameter on the client
An ICU collation has been applied to the database
Clients are accessing the database in client/server mode
CAUSE:
If no index is used to resolve a query, then the query can be resolved on either the client or the remote server. In this case, the query is being resolved by the remote server.
FIX:
Specify the appropriate -cpinternal and -cpcoll parameters for both the client and database broker, for example:
proserve testdb -H somehost -S someport -N tcp -cpinternal UTF-8 -cpcoll ICU-de__phonebook