New answers tagged

-3

Option Name Description NLS_LANG The current language, territory, and database character set, which are determined by session-wide globalization parameters. NLS_LANGUAGE The current language for the session. NLS_SORT The sequence of character values used when sorting or comparing text. To check the current NLS settings, type: select * from v$...


29

TL;DR There is no such thing as a "vendor-agnostic" view of Collations, nor even "version-agnostic", since their implementations -- including which aspects can be made insensitive and their naming conventions -- are vendor-specific and change over time. Here is a summary of what I have found, and the details are in the longer section below the line: RDBMS ...


0

My assumption is that this is why I don't have a choice of 'en_US' while creating new database If you're refering to "New Database..." dialog box in pgadmin, the collation list does not seem to be fed from pg_collate, but from the values of pg_database.datcollate plus the hard-coded C and POSIX. For example, I see 54 entries in my pg_collation, all of ...


1

pg_collation is a system table inside pg_catalog system catalog schema. It lists all available collations: https://www.postgresql.org/docs/9.5/static/catalog-pg-collation.html SELECT * FROM pg_collation; SELECT * FROM pg_collation WHERE collname='en_US'; pg_collation table belongs to pg_catalog schema. To list all tables in the pg_catalog schema, use \dS+...



Top 50 recent answers are included