Kbase P164665: How to configure accent insensitive searches with DataServer for Oracle
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
27/04/2010 |
|
Status: Unverified
GOAL:
How to configure accent insensitive searches with DataServer for Oracle?
GOAL:
How to configure an Oracle database to perform accent insensitive searches
FACT(s) (Environment):
Progress 9.x
OpenEdge 10.x
All Supported Operating Systems
Oracle DataServer
Oracle
FIX:
In order to enable accent insensitive searches and sorting for the DataServer for Oracle product, the Oracle database itself must be configured correctly. This involves setting both the NLS_COMP and NLS_SORT parameters appropriately. No real changes are required on the DataServer side as it is merely passing a result set generated by Oracle back to the client.
Suggested values for the NLS_COMP and NLS_SORT parameters are as follows:
Oracle 9.x
Set NLS_COMP to ANSI
Set NLS_SORT to GENERIC_BASELETTER
Oracle 10.x and later
Set NLS_COMP to LINGUISTIC
Set NLS_SORT to BINARY_AI
For further assistance/information on this topic, please contact Oracle Technical Support.