Wiki / Collations & Encodings

Definitions for PostgreSQL 18

• BIG5Client-only encodings10 – 20

  Big Five

  1011121314151617181920
• CBootstrap collations10 – 20

  standard C collation

  1011121314151617181920
• EUC_CNServer encodings10 – 20

  Extended UNIX Code-CN

  1011121314151617181920
• EUC_JIS_2004Server encodings10 – 20

  Extended UNIX Code-JP, JIS X 0213

  1011121314151617181920
• EUC_JPServer encodings10 – 20

  Extended UNIX Code-JP

  1011121314151617181920
• EUC_KRServer encodings10 – 20

  Extended UNIX Code-KR

  1011121314151617181920
• EUC_TWServer encodings10 – 20

  Extended UNIX Code-TW

  1011121314151617181920
• GB18030Client-only encodings10 – 20

  National Standard

  1011121314151617181920
• GBKClient-only encodings10 – 20

  Extended National Standard

  1011121314151617181920
• ISO_8859_5Server encodings10 – 20

  ISO 8859-5, ECMA 113

  1011121314151617181920
• ISO_8859_6Server encodings10 – 20

  ISO 8859-6, ECMA 114

  1011121314151617181920
• ISO_8859_7Server encodings10 – 20

  ISO 8859-7, ECMA 118

  1011121314151617181920
• ISO_8859_8Server encodings10 – 20

  ISO 8859-8, ECMA 121

  1011121314151617181920
• JOHABClient-only encodings10 – 20

  JOHAB

  1011121314151617181920
• KOI8RServer encodings10 – 20

  KOI 8-R

  1011121314151617181920
• KOI8UServer encodings10 – 20

  KOI 8-U

  1011121314151617181920
• LATIN1Server encodings10 – 20

  ISO 8859-1, ECMA 94

  1011121314151617181920
• LATIN10Server encodings10 – 20

  ISO 8859-16, ASRO SR 14111

  1011121314151617181920
• LATIN2Server encodings10 – 20

  ISO 8859-2, ECMA 94

  1011121314151617181920
• LATIN3Server encodings10 – 20

  ISO 8859-3, ECMA 94

  1011121314151617181920
• LATIN4Server encodings10 – 20

  ISO 8859-4, ECMA 94

  1011121314151617181920
• LATIN5Server encodings10 – 20

  ISO 8859-9, ECMA 128

  1011121314151617181920
• LATIN6Server encodings10 – 20

  ISO 8859-10, ECMA 144

  1011121314151617181920
• LATIN7Server encodings10 – 20

  ISO 8859-13

  1011121314151617181920
• LATIN8Server encodings10 – 20

  ISO 8859-14

  1011121314151617181920
• LATIN9Server encodings10 – 20

  ISO 8859-15

  1011121314151617181920
• MULE_INTERNALServer encodings10 – 18

  Mule internal code

  1011121314151617181920
• POSIXBootstrap collations10 – 20

  standard POSIX collation

  1011121314151617181920
• SHIFT_JIS_2004Client-only encodings10 – 20

  Shift JIS, JIS X 0213

  1011121314151617181920
• SJISClient-only encodings10 – 20

  Shift JIS

  1011121314151617181920
• SQL_ASCIIServer encodings10 – 20

  unspecified (see text)

  1011121314151617181920
• UHCClient-only encodings10 – 20

  Unified Hangul Code

  1011121314151617181920
• UTF8Server encodings10 – 20

  Unicode, 8-bit

  1011121314151617181920
• WIN1250Server encodings10 – 20

  Windows CP1250

  1011121314151617181920
• WIN1251Server encodings10 – 20

  Windows CP1251

  1011121314151617181920
• WIN1252Server encodings10 – 20

  Windows CP1252

  1011121314151617181920
• WIN1253Server encodings10 – 20

  Windows CP1253

  1011121314151617181920
• WIN1254Server encodings10 – 20

  Windows CP1254

  1011121314151617181920
• WIN1255Server encodings10 – 20

  Windows CP1255

  1011121314151617181920
• WIN1256Server encodings10 – 20

  Windows CP1256

  1011121314151617181920
• WIN1257Server encodings10 – 20

  Windows CP1257

  1011121314151617181920
• WIN1258Server encodings10 – 20

  Windows CP1258

  1011121314151617181920
• WIN866Server encodings10 – 20

  Windows CP866

  1011121314151617181920
• WIN874Server encodings10 – 20

  Windows CP874

  1011121314151617181920
• builtinCollation provider identities17 – 20

  builtin collation provider.

  1011121314151617181920
• defaultBootstrap collations10 – 20

  database's default collation

  1011121314151617181920
• defaultCollation provider identities10 – 20

  Database-default collation selector.

  1011121314151617181920
• icuCollation provider identities10 – 20

  icu collation provider.

  1011121314151617181920
• libcCollation provider identities10 – 20

  libc collation provider.

  1011121314151617181920
• pg_c_utf8Bootstrap collations17 – 20

  sorts by Unicode code point; Unicode and POSIX character semantics

  1011121314151617181920
• pg_unicode_fastBootstrap collations18 – 20

  sorts by Unicode code point; Unicode character semantics

  1011121314151617181920
• ucs_basicBootstrap collations16 – 20

  sorts by Unicode code point, C character semantics

  1011121314151617181920
• unicodeBootstrap collations16 – 20

  sorts using the Unicode Collation Algorithm with default settings

  1011121314151617181920