↑↓ select↵ open⌫ change scopeOpen full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Wiki / Versions

Built-in, platform independent immutable collation

Recorded source states and original language descriptions. Missing version evidence stays unknown.

The source snapshot records transitions for PostgreSQL 8.1–18. The historical matrix records independent cells for 7.4–18. Neither records support for PostgreSQL 19 or 20; newer versions remain unknown. These source claims are distinct from runtime measurements.

Internationalisation

Description

PostgreSQL has a built-in, platform independent immutable collation provider that supports C and C.UTF-8 collations. For more information, see standard collations.

Selected version: PostgreSQL 18

Yes

20191817161514131211109.69.59.49.39.29.19.08.48.38.28.18.07.4
UnknownUnknownYesYesNoNoNoNoNoNoNoNoNoNoNoNoNoNoNoNoNoNoUnknownUnknown

Compare versions

Original documentation links

Recorded legacy identifiers: 426

Complete source facts and provenance

yaml · center · 1dd22bf9a7f3ec325b894e2836fda535a25529f246a94dd41d6abbfe9997f7fd

{
  "Key": "built-in-platform-independent-immutable-collation",
  "SourceKind": "yaml",
  "SourceDatabase": "center",
  "SourceTable": "featurematrix.yaml",
  "SourceKey": "Built-in, platform independent immutable collation",
  "SourceHash": "1dd22bf9a7f3ec325b894e2836fda535a25529f246a94dd41d6abbfe9997f7fd",
  "Name": "Built-in, platform independent immutable collation",
  "NameLocale": "en",
  "GroupKey": "internationalisation",
  "GroupName": "Internationalisation",
  "GroupLocale": "en",
  "Ordinal": 0,
  "GroupOrder": 21,
  "Facts": {
    "feature": {
      "description": "PostgreSQL has a built-in, platform independent immutable collation provider that supports C and C.UTF-8 collations. For more information, see [standard collations](https://www.postgresql.org/docs/17/collation.html#COLLATION-MANAGING-STANDARD).",
      "name": "Built-in, platform independent immutable collation",
      "versions": {
        "17": "Yes"
      }
    },
    "group": "Internationalisation",
    "versions": {
      "max": 18,
      "min": 8.1
    }
  },
  "Cells": [
    {
      "Version": "10",
      "State": "no",
      "EvidenceKind": "yaml-default-no",
      "TransitionVersion": "",
      "Supported": false,
      "Original": "No"
    },
    {
      "Version": "11",
      "State": "no",
      "EvidenceKind": "yaml-default-no",
      "TransitionVersion": "",
      "Supported": false,
      "Original": "No"
    },
    {
      "Version": "12",
      "State": "no",
      "EvidenceKind": "yaml-default-no",
      "TransitionVersion": "",
      "Supported": false,
      "Original": "No"
    },
    {
      "Version": "13",
      "State": "no",
      "EvidenceKind": "yaml-default-no",
      "TransitionVersion": "",
      "Supported": false,
      "Original": "No"
    },
    {
      "Version": "14",
      "State": "no",
      "EvidenceKind": "yaml-default-no",
      "TransitionVersion": "",
      "Supported": false,
      "Original": "No"
    },
    {
      "Version": "15",
      "State": "no",
      "EvidenceKind": "yaml-default-no",
      "TransitionVersion": "",
      "Supported": false,
      "Original": "No"
    },
    {
      "Version": "16",
      "State": "no",
      "EvidenceKind": "yaml-default-no",
      "TransitionVersion": "",
      "Supported": false,
      "Original": "No"
    },
    {
      "Version": "17",
      "State": "yes",
      "EvidenceKind": "yaml-transition",
      "TransitionVersion": "17",
      "Supported": true,
      "Original": "Yes"
    },
    {
      "Version": "18",
      "State": "yes",
      "EvidenceKind": "yaml-transition",
      "TransitionVersion": "17",
      "Supported": true,
      "Original": "Yes"
    },
    {
      "Version": "8.1",
      "State": "no",
      "EvidenceKind": "yaml-default-no",
      "TransitionVersion": "",
      "Supported": false,
      "Original": "No"
    },
    {
      "Version": "8.2",
      "State": "no",
      "EvidenceKind": "yaml-default-no",
      "TransitionVersion": "",
      "Supported": false,
      "Original": "No"
    },
    {
      "Version": "8.3",
      "State": "no",
      "EvidenceKind": "yaml-default-no",
      "TransitionVersion": "",
      "Supported": false,
      "Original": "No"
    },
    {
      "Version": "8.4",
      "State": "no",
      "EvidenceKind": "yaml-default-no",
      "TransitionVersion": "",
      "Supported": false,
      "Original": "No"
    },
    {
      "Version": "9.0",
      "State": "no",
      "EvidenceKind": "yaml-default-no",
      "TransitionVersion": "",
      "Supported": false,
      "Original": "No"
    },
    {
      "Version": "9.1",
      "State": "no",
      "EvidenceKind": "yaml-default-no",
      "TransitionVersion": "",
      "Supported": false,
      "Original": "No"
    },
    {
      "Version": "9.2",
      "State": "no",
      "EvidenceKind": "yaml-default-no",
      "TransitionVersion": "",
      "Supported": false,
      "Original": "No"
    },
    {
      "Version": "9.3",
      "State": "no",
      "EvidenceKind": "yaml-default-no",
      "TransitionVersion": "",
      "Supported": false,
      "Original": "No"
    },
    {
      "Version": "9.4",
      "State": "no",
      "EvidenceKind": "yaml-default-no",
      "TransitionVersion": "",
      "Supported": false,
      "Original": "No"
    },
    {
      "Version": "9.5",
      "State": "no",
      "EvidenceKind": "yaml-default-no",
      "TransitionVersion": "",
      "Supported": false,
      "Original": "No"
    },
    {
      "Version": "9.6",
      "State": "no",
      "EvidenceKind": "yaml-default-no",
      "TransitionVersion": "",
      "Supported": false,
      "Original": "No"
    }
  ],
  "Texts": [
    {
      "Locale": "en",
      "Title": "Built-in, platform independent immutable collation",
      "BodyHTML": "\u003cp\u003ePostgreSQL has a built-in, platform independent immutable collation provider that supports C and C.UTF-8 collations. For more information, see \u003ca href=\"https://www.postgresql.org/docs/17/collation.html#COLLATION-MANAGING-STANDARD\" rel=\"nofollow\"\u003estandard collations\u003c/a\u003e.\u003c/p\u003e\n",
      "SourceHash": "1dd22bf9a7f3ec325b894e2836fda535a25529f246a94dd41d6abbfe9997f7fd",
      "ContentHash": "3de3b1b7f67fc825d39da91be9d7d52b7455ce52d488e5b24c377b2f4cb1c5e3",
      "Payload": {
        "description": "PostgreSQL has a built-in, platform independent immutable collation provider that supports C and C.UTF-8 collations. For more information, see [standard collations](https://www.postgresql.org/docs/17/collation.html#COLLATION-MANAGING-STANDARD).",
        "name": "Built-in, platform independent immutable collation",
        "versions": {
          "17": "Yes"
        }
      }
    },
    {
      "Locale": "zh-Hans",
      "Title": "内置、平台无关且不可变的排序规则",
      "BodyHTML": "\u003cp\u003ePostgreSQL 新增内置、平台无关且不可变的排序规则提供器,支持 \u003ccode\u003eC\u003c/code\u003e 和 \u003ccode\u003eC.UTF-8\u003c/code\u003e 排序规则。\u003c/p\u003e\n",
      "SourceHash": "071091951021357a5f492adb04caed6febf4d315ac2626ca027a48dd8ec01d50",
      "ContentHash": "4d3caf3edcbcc8b63d5f0c1e0607cac54ee108e34caeeca397c353195b5a0734",
      "Payload": {
        "description": "PostgreSQL 新增内置、平台无关且不可变的排序规则提供器,支持 `C` 和 `C.UTF-8` 排序规则。",
        "name": "内置、平台无关且不可变的排序规则"
      }
    }
  ],
  "GroupTitles": {
    "en": "Internationalisation",
    "zh-Hans": "国际化"
  },
  "LegacyIDs": [
    "426"
  ]
}

Complete source data JSON