Controlling Sort Order and Null Handling in Oracle with NLSSORT, NVL, NVL2, and NULLIF
In Oracle9i and later, sorting of Chinece text can follow phoneitc, radical, or stroke order instead of binary encoding. This behavior is controlled via the NLS_SORT setting. Available linguistic sorts: SCHINESE_RADICAL_M: Sort by radical first, then stroke count. SCHINESE_STROKE_M: Sort by stroke c...