Linguistic Sorting - Frequently Asked Questions
(Doc ID 227335.1)
Last updated on FEBRUARY 03, 2019
Applies to:Oracle Database - Standard Edition - Version 18.104.22.168 and later
Oracle Database - Enterprise Edition - Version 22.214.171.124 and later
Information in this document applies to any platform.
To provide an entry point for using Linguistic sorting and answer often asked questions.
Any DBA or developer who's looking into Linguistic sorting.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document
|1. Why is a sort order different on one client than on another / my init.ora settings are not used?|
|2. Why are strings like a-a ab- and a-c so strange sorted or "punctuation" characters ( /.;,-_ etc) sometimes ignored ?|
|3. What SQL operations are influenced by NLS_SORT and NLS_COMP?|
|4. Are indexes used with NLS_SORT set to anything else than BINARY?|
|5. Why do Accent- and Case Insensitive (_AI and _CI) SORTs not appear in V$NLS_VALID_VALUES?|
|6. SLOVAK and XSLOVAK sorting is not correct in 8i and 9i|
|7. Are there Asian Linguistic Sorts available?|
|8. Upper and lower function don't work as expected in Turkish for i and I characters.|
|9. Why is a Case Insensitive sort not working on a (N)CLob?|
|10. Can I (and should I) set Lingustic sorting on database/instance level ?|
|11. Known problems using NLS_COMP=LINGUISTIC or NLS_SORT to other than BINARY.|
|12. Known problems when using function (linguistic) based indexes (FBI).|