Is there a way to add exceptions for (\,/,blank) on GENERIC_M NLS_SORT at session level ?
Hi,
How to sort like : \,/,blank,1,2,a,A,à,b,... and after sort like 1,2,a,A,à,b,...
Tests done
""""""""""
We tried the following:
A) Binary and linguistic sort
=> We succeed to sort like 1,2,a,A,à,b,... when using multilingual linguistic sorts such as GENERIC_M but this don't work for special characters used in path (\,/,blank) : see results
Example:
Br Li/Di
Br Li/Ti
Br/Br Di
Expected: Br... should always come before Br Li/...
To fix I try to create new custom linguistic sort using Oracle local builder but this generate a side effect on deployment
It seems that we will not be able to apply this solution because:
How to sort like : \,/,blank,1,2,a,A,à,b,... and after sort like 1,2,a,A,à,b,...
Tests done
""""""""""
We tried the following:
A) Binary and linguistic sort
=> We succeed to sort like 1,2,a,A,à,b,... when using multilingual linguistic sorts such as GENERIC_M but this don't work for special characters used in path (\,/,blank) : see results
Example:
Br Li/Di
Br Li/Ti
Br/Br Di
Expected: Br... should always come before Br Li/...
To fix I try to create new custom linguistic sort using Oracle local builder but this generate a side effect on deployment
It seems that we will not be able to apply this solution because:
0