Search notes:

Oracle SQL function: CONVERT

convert converts a string from one character set to another.
Oracle discourages using convert, possibly in favor of utl_raw.convert.
declare
    nls_charset  varchar2(20);
    nls_charsetn varchar2(20);
    
    text_from     varchar2(30) := 'René';
    text_to      nvarchar2(30);
begin
   select value into nls_charset  from nls_database_parameters where parameter = 'NLS_CHARACTERSET'      ;
   select value into nls_charsetn from nls_database_parameters where parameter = 'NLS_NCHAR_CHARACTERSET';

   dbms_output.put_line('Converting from ' || nls_charset || ' to ' || nls_charsetn);
   text_to := convert(text_from, nls_charsetn, nls_charset);
   
   for r in (select
      dump(text_from, 16, 1, lengthb(text_from)) a,
      dump(text_to  , 16, 1, lengthb(text_to  )) b
   from
      dual
   ) loop
      dbms_output.put_line(r.a);
      dbms_output.put_line(r.b);
   end loop;
end;
/

See also

utl_raw.convert
Text related SQL functions

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:78 Stack trace: #0 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(78): PDOStatement->execute(Array) #1 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(30): insert_webrequest_('/notes/developm...', 1759414055, '216.73.216.42', 'Mozilla/5.0 App...', NULL) #2 /home/httpd/vhosts/renenyffenegger.ch/httpsdocs/notes/development/databases/Oracle/SQL/functions/text/convert(68): insert_webrequest() #3 {main} thrown in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php on line 78