{"Entry":{"collection":"locale","key":"collation-ucs-basic","name":"ucs_basic","aliases":[],"metadata":{"aliases":[],"category":"Bootstrap collations","content_hash":"6caa27a37b62c2a69454ec493ef6d16d8627ddc0a761a4ade8e08bf0bc0a7a1a","imported_at":"2026-09-30T00:40:33.427342+08:00","name":"ucs_basic","name_zh":"","slug":"collation-ucs-basic","summary":"sorts by Unicode code point, C character semantics"}},"Definition":{"Collection":"locale","Key":"collation-ucs-basic","SourceDatabase":"center","Version":"18","SourceTable":"collation_encoding","SourceKey":"collation-ucs-basic","SourceRevision":"555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f","Facts":{"aliases":[],"attributes":{"collcollate":"_null_","collctype":"_null_","collencoding":"6","collicurules":"_null_","collisdeterministic":"t","colllocale":"C","collname":"ucs_basic","collprovider":"b","collversion":"1"},"catalog":{"collcollate":"_null_","collctype":"_null_","collencoding":"6","collicurules":"_null_","collisdeterministic":"t","colllocale":"C","collname":"ucs_basic","collnamespace":"pg_catalog","collowner":"POSTGRES","collprovider":"b","collversion":"1","descr":"sorts by Unicode code point, C character semantics","oid":"962"},"comparison_data":{"collencoding":"6","collisdeterministic":"t","collname":"ucs_basic","collprovider":"b","collversion":"1","locale":"C"},"comparison_hash":"86c0088f0a36366d9cb9b61a811c53602577b264c223e74c14c87e7d001fe678","description":["sorts by Unicode code point, C character semantics"],"facts":[{"label":"Collisdeterministic","value":"t"},{"label":"Collcollate","value":"_null_"},{"label":"Collctype","value":"_null_"},{"label":"Colllocale","value":"C"},{"label":"Collicurules","value":"_null_"},{"label":"Collversion","value":"1"},{"label":"Collname","value":"ucs_basic"},{"label":"Collprovider","value":"b"},{"label":"Collencoding","value":"6"}],"manual_html":"\u003cdiv class=\"sect3\" id=\"COLLATION-MANAGING-STANDARD\"\u003e\n\u003cdiv class=\"titlepage\"\u003e\n\u003cdiv\u003e\n\u003cdiv\u003e\n\u003ch4 class=\"title\"\u003e23.2.2.1. Standard Collations \u003c/h4\u003e\n\u003c/div\u003e\n\u003c/div\u003e\n\u003c/div\u003e\n\u003cp\u003eOn all platforms, the following collations are supported:\u003c/p\u003e\n\u003cdiv class=\"variablelist\"\u003e\n\u003cdl class=\"variablelist\"\u003e\n\u003cdt\u003e\u003cspan class=\"term\"\u003e\u003ccode class=\"literal\"\u003eunicode\u003c/code\u003e\u003c/span\u003e\u003c/dt\u003e\n\u003cdd\u003e\n\u003cp\u003eThis SQL standard collation sorts using the Unicode Collation Algorithm with the Default Unicode Collation Element Table. It is available in all encodings. ICU support is required to use this collation, and behavior may change if \u003cspan class=\"productname\"\u003ePostgreSQL\u003c/span\u003e is built with a different version of ICU. (This collation has the same behavior as the ICU root locale; see \u003ca class=\"xref\" href=\"/docs/18/collation.html#COLLATION-MANAGING-PREDEFINED-ICU-UND-X-ICU\"\u003e\u003ccode class=\"literal\"\u003eund-x-icu\u003c/code\u003e (for \u003cspan class=\"quote\"\u003e“\u003cspan class=\"quote\"\u003eundefined\u003c/span\u003e”\u003c/span\u003e)\u003c/a\u003e.)\u003c/p\u003e\n\u003c/dd\u003e\n\u003cdt\u003e\u003cspan class=\"term\"\u003e\u003ccode class=\"literal\"\u003eucs_basic\u003c/code\u003e\u003c/span\u003e\u003c/dt\u003e\n\u003cdd\u003e\n\u003cp\u003eThis SQL standard collation sorts using the Unicode code point values rather than natural language order, and only the ASCII letters \u003cspan class=\"quote\"\u003e“\u003cspan class=\"quote\"\u003e\u003ccode class=\"literal\"\u003eA\u003c/code\u003e\u003c/span\u003e”\u003c/span\u003e through \u003cspan class=\"quote\"\u003e“\u003cspan class=\"quote\"\u003e\u003ccode class=\"literal\"\u003eZ\u003c/code\u003e\u003c/span\u003e”\u003c/span\u003e are treated as letters. The behavior is efficient and stable across all versions. Only available for encoding \u003ccode class=\"literal\"\u003eUTF8\u003c/code\u003e. (This collation has the same behavior as the libc locale specification \u003ccode class=\"literal\"\u003eC\u003c/code\u003e in \u003ccode class=\"literal\"\u003eUTF8\u003c/code\u003e encoding.)\u003c/p\u003e\n\u003c/dd\u003e\n\u003cdt\u003e\u003cspan class=\"term\"\u003e\u003ccode class=\"literal\"\u003epg_unicode_fast\u003c/code\u003e\u003c/span\u003e\u003c/dt\u003e\n\u003cdd\u003e\n\u003cp\u003eThis collation sorts by Unicode code point values rather than natural language order. For the functions \u003ccode class=\"function\"\u003elower\u003c/code\u003e, \u003ccode class=\"function\"\u003einitcap\u003c/code\u003e, and \u003ccode class=\"function\"\u003eupper\u003c/code\u003e it uses Unicode full case mapping. For pattern matching (including regular expressions), it uses the Standard variant of Unicode \u003ca class=\"ulink\" href=\"https://www.unicode.org/reports/tr18/#Compatibility_Properties\"\u003eCompatibility Properties\u003c/a\u003e. Behavior is efficient and stable within a \u003cspan class=\"productname\"\u003ePostgres\u003c/span\u003e major version. It is only available for encoding \u003ccode class=\"literal\"\u003eUTF8\u003c/code\u003e.\u003c/p\u003e\n\u003c/dd\u003e\n\u003cdt\u003e\u003cspan class=\"term\"\u003e\u003ccode class=\"literal\"\u003epg_c_utf8\u003c/code\u003e\u003c/span\u003e\u003c/dt\u003e\n\u003cdd\u003e\n\u003cp\u003eThis collation sorts by Unicode code point values rather than natural language order. For the functions \u003ccode class=\"function\"\u003elower\u003c/code\u003e, \u003ccode class=\"function\"\u003einitcap\u003c/code\u003e, and \u003ccode class=\"function\"\u003eupper\u003c/code\u003e, it uses Unicode simple case mapping. For pattern matching (including regular expressions), it uses the POSIX Compatible variant of Unicode \u003ca class=\"ulink\" href=\"https://www.unicode.org/reports/tr18/#Compatibility_Properties\"\u003eCompatibility Properties\u003c/a\u003e. Behavior is efficient and stable within a \u003cspan class=\"productname\"\u003ePostgreSQL\u003c/span\u003e major version. This collation is only available for encoding \u003ccode class=\"literal\"\u003eUTF8\u003c/code\u003e.\u003c/p\u003e\n\u003c/dd\u003e\n\u003cdt\u003e\u003cspan class=\"term\"\u003e\u003ccode class=\"literal\"\u003eC\u003c/code\u003e (equivalent to \u003ccode class=\"literal\"\u003ePOSIX\u003c/code\u003e)\u003c/span\u003e\u003c/dt\u003e\n\u003cdd\u003e\n\u003cp\u003eThe \u003ccode class=\"literal\"\u003eC\u003c/code\u003e and \u003ccode class=\"literal\"\u003ePOSIX\u003c/code\u003e collations are based on \u003cspan class=\"quote\"\u003e“\u003cspan class=\"quote\"\u003etraditional C\u003c/span\u003e”\u003c/span\u003e behavior. They sort by byte values rather than natural language order, and only the ASCII letters \u003cspan class=\"quote\"\u003e“\u003cspan class=\"quote\"\u003e\u003ccode class=\"literal\"\u003eA\u003c/code\u003e\u003c/span\u003e”\u003c/span\u003e through \u003cspan class=\"quote\"\u003e“\u003cspan class=\"quote\"\u003e\u003ccode class=\"literal\"\u003eZ\u003c/code\u003e\u003c/span\u003e”\u003c/span\u003e are treated as letters. The behavior is efficient and stable across all versions for a given database encoding, but behavior may vary between different database encodings.\u003c/p\u003e\n\u003c/dd\u003e\n\u003cdt\u003e\u003cspan class=\"term\"\u003e\u003ccode class=\"literal\"\u003edefault\u003c/code\u003e\u003c/span\u003e\u003c/dt\u003e\n\u003cdd\u003e\n\u003cp\u003eThe \u003ccode class=\"literal\"\u003edefault\u003c/code\u003e collation selects the locale specified at database creation time.\u003c/p\u003e\n\u003c/dd\u003e\n\u003c/dl\u003e\n\u003c/div\u003e\n\u003cp\u003eAdditional collations may be available depending on operating system support. The efficiency and stability of these additional collations depend on the collation provider, the provider version, and the locale.\u003c/p\u003e\n\u003c/div\u003e","manual_path":"/docs/18/collation.html#COLLATION-MANAGING-STANDARD","related":[{"label":"builtin provider","url":"/wiki/locale/provider-builtin/?v=18"}],"release":{"catalog_fingerprint":"65c93d6048ef30e61023a84f9680fa6a92b1c383b7eb226741170077eb078502","channel":"stable","label":"18.6","major":"18","ref":"https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2","revision":"555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f","source_sha256":"555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f"},"sections":[],"signature":"","source_oid":"962","sources":[{"label":"Matching PostgreSQL source archive","sha256":"555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f","url":"https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2"},{"label":"PostgreSQL 18 English manual","path":"collation.html","sha256":"c98cbca2b2235a896f7fe438a88a99b8d6b9d1f50bdb49fe2794e9982a50797f","url":"/docs/18/collation.html#COLLATION-MANAGING-STANDARD"}],"tables":[]},"ManualEvidence":{"manual_path":"/docs/18/collation.html#COLLATION-MANAGING-STANDARD","release":{"catalog_fingerprint":"65c93d6048ef30e61023a84f9680fa6a92b1c383b7eb226741170077eb078502","channel":"stable","label":"18.6","major":"18","ref":"https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2","revision":"555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f","source_sha256":"555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f"},"sources":[{"label":"Matching PostgreSQL source archive","sha256":"555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f","url":"https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2"},{"label":"PostgreSQL 18 English manual","path":"collation.html","sha256":"c98cbca2b2235a896f7fe438a88a99b8d6b9d1f50bdb49fe2794e9982a50797f","url":"/docs/18/collation.html#COLLATION-MANAGING-STANDARD"}]},"MeasuredEvidence":{}},"Text":{"Collection":"locale","Key":"collation-ucs-basic","SourceDatabase":"center","Version":"18","Locale":"en","Title":"ucs_basic","Summary":"sorts by Unicode code point, C character semantics","BodyHTML":"\u003cdiv id=\"COLLATION-MANAGING-STANDARD\"\u003e\n\u003cdiv\u003e\n\u003cdiv\u003e\n\u003cdiv\u003e\n\u003ch4\u003e23.2.2.1. Standard Collations \u003c/h4\u003e\n\u003c/div\u003e\n\u003c/div\u003e\n\u003c/div\u003e\n\u003cp\u003eOn all platforms, the following collations are supported:\u003c/p\u003e\n\u003cdiv\u003e\n\u003cdl\u003e\n\u003cdt\u003e\u003cspan\u003e\u003ccode\u003eunicode\u003c/code\u003e\u003c/span\u003e\u003c/dt\u003e\n\u003cdd\u003e\n\u003cp\u003eThis SQL standard collation sorts using the Unicode Collation Algorithm with the Default Unicode Collation Element Table. It is available in all encodings. ICU support is required to use this collation, and behavior may change if \u003cspan\u003ePostgreSQL\u003c/span\u003e is built with a different version of ICU. (This collation has the same behavior as the ICU root locale; see \u003ca href=\"/docs/18/collation.html#COLLATION-MANAGING-PREDEFINED-ICU-UND-X-ICU\" rel=\"nofollow\"\u003e\u003ccode\u003eund-x-icu\u003c/code\u003e (for \u003cspan\u003e“\u003cspan\u003eundefined\u003c/span\u003e”\u003c/span\u003e)\u003c/a\u003e.)\u003c/p\u003e\n\u003c/dd\u003e\n\u003cdt\u003e\u003cspan\u003e\u003ccode\u003eucs_basic\u003c/code\u003e\u003c/span\u003e\u003c/dt\u003e\n\u003cdd\u003e\n\u003cp\u003eThis SQL standard collation sorts using the Unicode code point values rather than natural language order, and only the ASCII letters \u003cspan\u003e“\u003cspan\u003e\u003ccode\u003eA\u003c/code\u003e\u003c/span\u003e”\u003c/span\u003e through \u003cspan\u003e“\u003cspan\u003e\u003ccode\u003eZ\u003c/code\u003e\u003c/span\u003e”\u003c/span\u003e are treated as letters. The behavior is efficient and stable across all versions. Only available for encoding \u003ccode\u003eUTF8\u003c/code\u003e. (This collation has the same behavior as the libc locale specification \u003ccode\u003eC\u003c/code\u003e in \u003ccode\u003eUTF8\u003c/code\u003e encoding.)\u003c/p\u003e\n\u003c/dd\u003e\n\u003cdt\u003e\u003cspan\u003e\u003ccode\u003epg_unicode_fast\u003c/code\u003e\u003c/span\u003e\u003c/dt\u003e\n\u003cdd\u003e\n\u003cp\u003eThis collation sorts by Unicode code point values rather than natural language order. For the functions \u003ccode\u003elower\u003c/code\u003e, \u003ccode\u003einitcap\u003c/code\u003e, and \u003ccode\u003eupper\u003c/code\u003e it uses Unicode full case mapping. For pattern matching (including regular expressions), it uses the Standard variant of Unicode \u003ca href=\"https://www.unicode.org/reports/tr18/#Compatibility_Properties\" rel=\"nofollow\"\u003eCompatibility Properties\u003c/a\u003e. Behavior is efficient and stable within a \u003cspan\u003ePostgres\u003c/span\u003e major version. It is only available for encoding \u003ccode\u003eUTF8\u003c/code\u003e.\u003c/p\u003e\n\u003c/dd\u003e\n\u003cdt\u003e\u003cspan\u003e\u003ccode\u003epg_c_utf8\u003c/code\u003e\u003c/span\u003e\u003c/dt\u003e\n\u003cdd\u003e\n\u003cp\u003eThis collation sorts by Unicode code point values rather than natural language order. For the functions \u003ccode\u003elower\u003c/code\u003e, \u003ccode\u003einitcap\u003c/code\u003e, and \u003ccode\u003eupper\u003c/code\u003e, it uses Unicode simple case mapping. For pattern matching (including regular expressions), it uses the POSIX Compatible variant of Unicode \u003ca href=\"https://www.unicode.org/reports/tr18/#Compatibility_Properties\" rel=\"nofollow\"\u003eCompatibility Properties\u003c/a\u003e. Behavior is efficient and stable within a \u003cspan\u003ePostgreSQL\u003c/span\u003e major version. This collation is only available for encoding \u003ccode\u003eUTF8\u003c/code\u003e.\u003c/p\u003e\n\u003c/dd\u003e\n\u003cdt\u003e\u003cspan\u003e\u003ccode\u003eC\u003c/code\u003e (equivalent to \u003ccode\u003ePOSIX\u003c/code\u003e)\u003c/span\u003e\u003c/dt\u003e\n\u003cdd\u003e\n\u003cp\u003eThe \u003ccode\u003eC\u003c/code\u003e and \u003ccode\u003ePOSIX\u003c/code\u003e collations are based on \u003cspan\u003e“\u003cspan\u003etraditional C\u003c/span\u003e”\u003c/span\u003e behavior. They sort by byte values rather than natural language order, and only the ASCII letters \u003cspan\u003e“\u003cspan\u003e\u003ccode\u003eA\u003c/code\u003e\u003c/span\u003e”\u003c/span\u003e through \u003cspan\u003e“\u003cspan\u003e\u003ccode\u003eZ\u003c/code\u003e\u003c/span\u003e”\u003c/span\u003e are treated as letters. The behavior is efficient and stable across all versions for a given database encoding, but behavior may vary between different database encodings.\u003c/p\u003e\n\u003c/dd\u003e\n\u003cdt\u003e\u003cspan\u003e\u003ccode\u003edefault\u003c/code\u003e\u003c/span\u003e\u003c/dt\u003e\n\u003cdd\u003e\n\u003cp\u003eThe \u003ccode\u003edefault\u003c/code\u003e collation selects the locale specified at database creation time.\u003c/p\u003e\n\u003c/dd\u003e\n\u003c/dl\u003e\n\u003c/div\u003e\n\u003cp\u003eAdditional collations may be available depending on operating system support. The efficiency and stability of these additional collations depend on the collation provider, the provider version, and the locale.\u003c/p\u003e\n\u003c/div\u003e","SourceRevision":"555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f","ContentHash":"afe75c8568bfaa7a81fd811e2bee13ed38d1af12b5383482cfb2b824e6ac4139","Payload":{"description":["sorts by Unicode code point, C character semantics"],"manual_html":"\u003cdiv class=\"sect3\" id=\"COLLATION-MANAGING-STANDARD\"\u003e\n\u003cdiv class=\"titlepage\"\u003e\n\u003cdiv\u003e\n\u003cdiv\u003e\n\u003ch4 class=\"title\"\u003e23.2.2.1. Standard Collations \u003c/h4\u003e\n\u003c/div\u003e\n\u003c/div\u003e\n\u003c/div\u003e\n\u003cp\u003eOn all platforms, the following collations are supported:\u003c/p\u003e\n\u003cdiv class=\"variablelist\"\u003e\n\u003cdl class=\"variablelist\"\u003e\n\u003cdt\u003e\u003cspan class=\"term\"\u003e\u003ccode class=\"literal\"\u003eunicode\u003c/code\u003e\u003c/span\u003e\u003c/dt\u003e\n\u003cdd\u003e\n\u003cp\u003eThis SQL standard collation sorts using the Unicode Collation Algorithm with the Default Unicode Collation Element Table. It is available in all encodings. ICU support is required to use this collation, and behavior may change if \u003cspan class=\"productname\"\u003ePostgreSQL\u003c/span\u003e is built with a different version of ICU. (This collation has the same behavior as the ICU root locale; see \u003ca class=\"xref\" href=\"/docs/18/collation.html#COLLATION-MANAGING-PREDEFINED-ICU-UND-X-ICU\"\u003e\u003ccode class=\"literal\"\u003eund-x-icu\u003c/code\u003e (for \u003cspan class=\"quote\"\u003e“\u003cspan class=\"quote\"\u003eundefined\u003c/span\u003e”\u003c/span\u003e)\u003c/a\u003e.)\u003c/p\u003e\n\u003c/dd\u003e\n\u003cdt\u003e\u003cspan class=\"term\"\u003e\u003ccode class=\"literal\"\u003eucs_basic\u003c/code\u003e\u003c/span\u003e\u003c/dt\u003e\n\u003cdd\u003e\n\u003cp\u003eThis SQL standard collation sorts using the Unicode code point values rather than natural language order, and only the ASCII letters \u003cspan class=\"quote\"\u003e“\u003cspan class=\"quote\"\u003e\u003ccode class=\"literal\"\u003eA\u003c/code\u003e\u003c/span\u003e”\u003c/span\u003e through \u003cspan class=\"quote\"\u003e“\u003cspan class=\"quote\"\u003e\u003ccode class=\"literal\"\u003eZ\u003c/code\u003e\u003c/span\u003e”\u003c/span\u003e are treated as letters. The behavior is efficient and stable across all versions. Only available for encoding \u003ccode class=\"literal\"\u003eUTF8\u003c/code\u003e. (This collation has the same behavior as the libc locale specification \u003ccode class=\"literal\"\u003eC\u003c/code\u003e in \u003ccode class=\"literal\"\u003eUTF8\u003c/code\u003e encoding.)\u003c/p\u003e\n\u003c/dd\u003e\n\u003cdt\u003e\u003cspan class=\"term\"\u003e\u003ccode class=\"literal\"\u003epg_unicode_fast\u003c/code\u003e\u003c/span\u003e\u003c/dt\u003e\n\u003cdd\u003e\n\u003cp\u003eThis collation sorts by Unicode code point values rather than natural language order. For the functions \u003ccode class=\"function\"\u003elower\u003c/code\u003e, \u003ccode class=\"function\"\u003einitcap\u003c/code\u003e, and \u003ccode class=\"function\"\u003eupper\u003c/code\u003e it uses Unicode full case mapping. For pattern matching (including regular expressions), it uses the Standard variant of Unicode \u003ca class=\"ulink\" href=\"https://www.unicode.org/reports/tr18/#Compatibility_Properties\"\u003eCompatibility Properties\u003c/a\u003e. Behavior is efficient and stable within a \u003cspan class=\"productname\"\u003ePostgres\u003c/span\u003e major version. It is only available for encoding \u003ccode class=\"literal\"\u003eUTF8\u003c/code\u003e.\u003c/p\u003e\n\u003c/dd\u003e\n\u003cdt\u003e\u003cspan class=\"term\"\u003e\u003ccode class=\"literal\"\u003epg_c_utf8\u003c/code\u003e\u003c/span\u003e\u003c/dt\u003e\n\u003cdd\u003e\n\u003cp\u003eThis collation sorts by Unicode code point values rather than natural language order. For the functions \u003ccode class=\"function\"\u003elower\u003c/code\u003e, \u003ccode class=\"function\"\u003einitcap\u003c/code\u003e, and \u003ccode class=\"function\"\u003eupper\u003c/code\u003e, it uses Unicode simple case mapping. For pattern matching (including regular expressions), it uses the POSIX Compatible variant of Unicode \u003ca class=\"ulink\" href=\"https://www.unicode.org/reports/tr18/#Compatibility_Properties\"\u003eCompatibility Properties\u003c/a\u003e. Behavior is efficient and stable within a \u003cspan class=\"productname\"\u003ePostgreSQL\u003c/span\u003e major version. This collation is only available for encoding \u003ccode class=\"literal\"\u003eUTF8\u003c/code\u003e.\u003c/p\u003e\n\u003c/dd\u003e\n\u003cdt\u003e\u003cspan class=\"term\"\u003e\u003ccode class=\"literal\"\u003eC\u003c/code\u003e (equivalent to \u003ccode class=\"literal\"\u003ePOSIX\u003c/code\u003e)\u003c/span\u003e\u003c/dt\u003e\n\u003cdd\u003e\n\u003cp\u003eThe \u003ccode class=\"literal\"\u003eC\u003c/code\u003e and \u003ccode class=\"literal\"\u003ePOSIX\u003c/code\u003e collations are based on \u003cspan class=\"quote\"\u003e“\u003cspan class=\"quote\"\u003etraditional C\u003c/span\u003e”\u003c/span\u003e behavior. They sort by byte values rather than natural language order, and only the ASCII letters \u003cspan class=\"quote\"\u003e“\u003cspan class=\"quote\"\u003e\u003ccode class=\"literal\"\u003eA\u003c/code\u003e\u003c/span\u003e”\u003c/span\u003e through \u003cspan class=\"quote\"\u003e“\u003cspan class=\"quote\"\u003e\u003ccode class=\"literal\"\u003eZ\u003c/code\u003e\u003c/span\u003e”\u003c/span\u003e are treated as letters. The behavior is efficient and stable across all versions for a given database encoding, but behavior may vary between different database encodings.\u003c/p\u003e\n\u003c/dd\u003e\n\u003cdt\u003e\u003cspan class=\"term\"\u003e\u003ccode class=\"literal\"\u003edefault\u003c/code\u003e\u003c/span\u003e\u003c/dt\u003e\n\u003cdd\u003e\n\u003cp\u003eThe \u003ccode class=\"literal\"\u003edefault\u003c/code\u003e collation selects the locale specified at database creation time.\u003c/p\u003e\n\u003c/dd\u003e\n\u003c/dl\u003e\n\u003c/div\u003e\n\u003cp\u003eAdditional collations may be available depending on operating system support. The efficiency and stability of these additional collations depend on the collation provider, the provider version, and the locale.\u003c/p\u003e\n\u003c/div\u003e","related":[{"label":"builtin provider","url":"/wiki/locale/provider-builtin/?v=18"}],"sections":[],"tables":[]}},"RequestedLocale":"zh-Hans","Fallback":true,"Versions":["16","17","18","19","20"],"Locales":["en"],"Signatures":null,"Spellings":null,"SQLState":null,"Evidence":null}