Wiki / Collations & Encodings

Server encodings and collation providers with explicit locale and build-dependent boundaries.

Reading PostgreSQL 18.6.

Find an entry GroupAll groupsBootstrap collations (7)Client-only encodings (7)Collation provider identities (4)Server encodings (35) Apply

53 entries; 53 recorded in PostgreSQL 18.6.

• C Bootstrap collations

  standard C collation

  1011121314151617181920
• POSIX Bootstrap collations

  standard POSIX collation

  1011121314151617181920
• default Bootstrap collations

  database's default collation

  1011121314151617181920
• pg_c_utf8 Bootstrap collations

  sorts by Unicode code point; Unicode and POSIX character semantics

  1011121314151617181920
• pg_unicode_fast Bootstrap collations

  sorts by Unicode code point; Unicode character semantics

  1011121314151617181920
• ucs_basic Bootstrap collations

  sorts by Unicode code point, C character semantics

  1011121314151617181920
• unicode Bootstrap collations

  sorts using the Unicode Collation Algorithm with default settings

  1011121314151617181920
• BIG5 Client-only encodings

  Big Five

  1011121314151617181920
• GB18030 Client-only encodings

  National Standard

  1011121314151617181920
• GBK Client-only encodings

  Extended National Standard

  1011121314151617181920
• JOHAB Client-only encodings

  JOHAB

  1011121314151617181920
• SHIFT_JIS_2004 Client-only encodings

  Shift JIS, JIS X 0213

  1011121314151617181920
• SJIS Client-only encodings

  Shift JIS

  1011121314151617181920
• UHC Client-only encodings

  Unified Hangul Code

  1011121314151617181920
• builtin Collation provider identities

  builtin collation provider.

  1011121314151617181920
• default Collation provider identities

  Database-default collation selector.

  1011121314151617181920
• icu Collation provider identities

  icu collation provider.

  1011121314151617181920
• libc Collation provider identities

  libc collation provider.

  1011121314151617181920
• EUC_CN Server encodings

  Extended UNIX Code-CN

  1011121314151617181920
• EUC_JIS_2004 Server encodings

  Extended UNIX Code-JP, JIS X 0213

  1011121314151617181920
• EUC_JP Server encodings

  Extended UNIX Code-JP

  1011121314151617181920
• EUC_KR Server encodings

  Extended UNIX Code-KR

  1011121314151617181920
• EUC_TW Server encodings

  Extended UNIX Code-TW

  1011121314151617181920
• ISO_8859_5 Server encodings

  ISO 8859-5, ECMA 113

  1011121314151617181920
• ISO_8859_6 Server encodings

  ISO 8859-6, ECMA 114

  1011121314151617181920
• ISO_8859_7 Server encodings

  ISO 8859-7, ECMA 118

  1011121314151617181920
• ISO_8859_8 Server encodings

  ISO 8859-8, ECMA 121

  1011121314151617181920
• KOI8R Server encodings

  KOI 8-R

  1011121314151617181920
• KOI8U Server encodings

  KOI 8-U

  1011121314151617181920
• LATIN1 Server encodings

  ISO 8859-1, ECMA 94

  1011121314151617181920
• LATIN10 Server encodings

  ISO 8859-16, ASRO SR 14111

  1011121314151617181920
• LATIN2 Server encodings

  ISO 8859-2, ECMA 94

  1011121314151617181920
• LATIN3 Server encodings

  ISO 8859-3, ECMA 94

  1011121314151617181920
• LATIN4 Server encodings

  ISO 8859-4, ECMA 94

  1011121314151617181920
• LATIN5 Server encodings

  ISO 8859-9, ECMA 128

  1011121314151617181920
• LATIN6 Server encodings

  ISO 8859-10, ECMA 144

  1011121314151617181920
• LATIN7 Server encodings

  ISO 8859-13

  1011121314151617181920
• LATIN8 Server encodings

  ISO 8859-14

  1011121314151617181920
• LATIN9 Server encodings

  ISO 8859-15

  1011121314151617181920
• MULE_INTERNAL Server encodings

  Mule internal code

  1011121314151617181920
• SQL_ASCII Server encodings

  unspecified (see text)

  1011121314151617181920
• UTF8 Server encodings

  Unicode, 8-bit

  1011121314151617181920
• WIN1250 Server encodings

  Windows CP1250

  1011121314151617181920
• WIN1251 Server encodings

  Windows CP1251

  1011121314151617181920
• WIN1252 Server encodings

  Windows CP1252

  1011121314151617181920
• WIN1253 Server encodings

  Windows CP1253

  1011121314151617181920
• WIN1254 Server encodings

  Windows CP1254

  1011121314151617181920
• WIN1255 Server encodings

  Windows CP1255

  1011121314151617181920
• WIN1256 Server encodings

  Windows CP1256

  1011121314151617181920
• WIN1257 Server encodings

  Windows CP1257

  1011121314151617181920
• WIN1258 Server encodings

  Windows CP1258

  1011121314151617181920
• WIN866 Server encodings

  Windows CP866

  1011121314151617181920
• WIN874 Server encodings

  Windows CP874

  1011121314151617181920

RecordedFirst recordedInterface or attribute changeNo longer recorded

Squares indicate presence in sampled builds, not first introduction. Select a square for the same-version definition and sources.

Changes in PostgreSQL 18.6 · Export JSON

Reading this collection

Encoding identifiers, collation providers and explicitly bootstrapped collations are separate entries. Operating-system and ICU locale inventories vary by installation and are not a universal list. Client-only encodings are distinguished from server-capable encodings.