| Accent insensitive indexation [message #634261] |
Fri, 06 March 2015 11:40  |
 |
Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...
|
Senior Member
Account Moderator |
|
|
Here a question that has been sent to me and I can't answer.
We have an Oracle Text defaulted to French.
The question is: "is it possible to create a domain index in a way it is not sensitive to the accents?", that is (I think) it works in the same way if some accents are present or not in a text.
But maybe the question is not adequate, maybe the question should be "is there a way to search text so that it is accent insensitive?".
Or maybe the solution is the generic (not Oracle Text specific) one: use FRENCH_AI for NLS_SORT but I don't know if it will be sufficient to use with a domain index.
Waiting for your answers...
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
