Search notes:

Oracle SQL function: NLSSORT

nlssort(txt) returns a raw:
create table tq84_nlssort as
select
   nlssort(dummy ,'nls_sort=''GERMAN''') dummy_nlssort
from
   dual;
   
select
   data_type
from
   user_tab_cols
where
   table_name = 'TQ84_NLSSORT';
--
-- RAW
   
select * from tq84_nlssort;
--
-- 7D000200

drop table tq84_nlssort purge;

Getting Unicode representation of a string

With the unicode_binary collation, nlssort returns the Unicode codepoints for strings:
select
   nlssort(n'Ł'  , 'nls_sort=''unicode_binary''') L,
   nlssort(n'u'  , 'nls_sort=''unicode_binary''') u,
   nlssort(n'k'  , 'nls_sort=''unicode_binary''') l,
   nlssort(n'Łuk', 'nls_sort=''unicode_binary''') Luk
from
  dual;

See also

Functions related to text and strings

Index