Wiki / 排序规则与编码

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