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

Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php:51 Stack trace: #0 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(51): PDOStatement->execute(Array) #1 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(66): id_of(Object(PDO), 'uri', '/notes/developm...') #2 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(30): insert_webrequest_('/notes/developm...', 1758199814, '216.73.216.150', 'Mozilla/5.0 App...', NULL) #3 /home/httpd/vhosts/renenyffenegger.ch/httpsdocs/notes/development/databases/Oracle/SQL/functions/text/nlssort(68): insert_webrequest() #4 {main} thrown in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php on line 51