Contents
How to set collation and Ctype in PostgreSQL?
This is equivalent to specifying both –lc-collate and –lc-ctype. –lc-collate=locale Specifies the LC_COLLATE setting to be used in this database. –lc-ctype=locale Specifies the LC_CTYPE setting to be used in this database. Note that you can set collation for a table or a column, see a good tutorial on collations in PostgreSQL.
With ICU collations, either Postgres passes directly UTF-8 contents if it can, or it converts the strings to UTF-16, so again collations are not tied to a particular database encoding, contrary to the POSIX model and its family of strcoll functions. Thanks for contributing an answer to Database Administrators Stack Exchange!
How to collation PostgreSQL strings to UTF-16?
UTF8 has many characters that win1252 does not This is a Windows-specific thing, due to Windows not following the POSIX model with locales and collations. On Windows and with non-ICU collations, Postgres will convert the strings from the db encoding to UTF-16 ( wchar_t) and call wcscoll_l ().
Can you change the LC _ COLLATE and LC _ Ctype settings?
This alleviates the restriction that the LC_COLLATE and LC_CTYPE settings of a database cannot be changed after its creation. 23.2.1. Concepts Conceptually, every expression of a collatable data type has a collation.
Is the ICU collation of a given name always the same?
ICU does not support separate “collate” and “ctype” settings, so they are always the same. Also, ICU collations are independent of the encoding, so there is always only one ICU collation of a given name in a database. 23.2.2.1.
Is there an UTF8 collation in PostgreSQL-stack?
I think the Postgres 10 collation equivalent for utf8_general_ci (or more modern utf8_unicode_ci) is called und-x-icu – this is an undefined collation (not defined for any real world language) provided by an ICU library. This collation would sort quite reasonably characters from most languages.