Search notes:

Oracle: Globalization (NLS) related functions

Globalization (NLS) related SQL functions include

nls_charset_decl_len
nls_charset_id, nls_charset_name
nls_collation_id, nls_collation_name
nls_initcap
nls_lower, nls_upper
nlssort

NLS_CHARSET_ID / NLS_CHARSET_NAME

nls_charset_id returns a character set's CSID (which is used, for example, in dbms_lob.loadclobfromfile)

select nls_charset_id('we8mswin1252') from dual;
-- 178
   
select nls_charset_name(178) from dual;
-- WE8MSWIN1252

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...', 1745379836, '160.79.111.166', 'Mozilla/5.0 App...', NULL) #2 /home/httpd/vhosts/renenyffenegger.ch/httpsdocs/notes/development/databases/Oracle/SQL/functions/nls/index(54): insert_webrequest() #3 {main} thrown in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php on line 78

Oracle: Globalization (NLS) related functions

NLS_CHARSET_ID / NLS_CHARSET_NAME

See also