| Implementing Case-insensitive Search [message #553744] |
Tue, 08 May 2012 04:59  |
 |
orapratap
Messages: 134
Registered: November 2011
Location: Canada
|
Senior Member |
|
|
Hello
we are implementing case insensitive seaarch in our small 10g database
We would be modifying the following parameters
nls_comp=LINGUISTIC ;
nls_sort=binary_ci;
We want to use the existing indexes and as I understand we will need indexes created in following manner
create index <index_name> on <table_name>(nlssort( <column_name>, 'NLS_SORT=BINARY_CI'));
1) Is there any mechanism with which we can convert existing index to above type? (without drop and recreate)
One of the issue I can see is related to unique values as 'ABC', 'Abc' and 'abc' would be treated same
2) Apart from that is there any issue, added maintenance for such index?
Thanks and Regards
Orapratap
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
