{"kind": "locale", "major": "18", "item": {"slug": "collation-pg-unicode-fast", "name": "pg_unicode_fast", "name_zh": "", "category": "\u5185\u7f6e\u6392\u5e8f\u89c4\u5219", "summary": "\u6309 Unicode \u7801\u70b9\u6392\u5e8f\uff0c\u91c7\u7528 Unicode \u5b57\u7b26\u8bed\u4e49", "aliases": [], "content_hash": "c8275b850ae9b3638c554c35249086eab3c03274beaea87bc3c126fd41de2cdb", "versions": {"18": {"facts": [{"label": "\u662f\u5426\u786e\u5b9a\u6027\u6bd4\u8f83\uff08collisdeterministic\uff09", "value": "t"}, {"label": "\u6392\u5e8f\u533a\u57df\u8bbe\u7f6e\uff08collcollate\uff09", "value": "_null_"}, {"label": "\u5b57\u7b26\u5206\u7c7b\u533a\u57df\u8bbe\u7f6e\uff08collctype\uff09", "value": "_null_"}, {"label": "\u533a\u57df\u8bbe\u7f6e\uff08colllocale\uff09", "value": "PG_UNICODE_FAST"}, {"label": "ICU \u89c4\u5219\uff08collicurules\uff09", "value": "_null_"}, {"label": "\u63d0\u4f9b\u8005\u7248\u672c\uff08collversion\uff09", "value": "1"}, {"label": "\u6392\u5e8f\u89c4\u5219\u540d\u79f0\uff08collname\uff09", "value": "pg_unicode_fast"}, {"label": "\u6392\u5e8f\u89c4\u5219\u63d0\u4f9b\u8005\uff08collprovider\uff09", "value": "b"}, {"label": "\u5b57\u7b26\u7f16\u7801\uff08collencoding\uff09", "value": "6"}], "tables": [], "aliases": [], "catalog": {"oid": "6411", "descr": "sorts by Unicode code point; Unicode character semantics", "collname": "pg_unicode_fast", "collctype": "_null_", "collowner": "POSTGRES", "colllocale": "PG_UNICODE_FAST", "collcollate": "_null_", "collversion": "1", "collencoding": "6", "collicurules": "_null_", "collprovider": "b", "collnamespace": "pg_catalog", "collisdeterministic": "t"}, "related": [{"url": "/wiki/locale/provider-builtin/?v=18", "label": "builtin \u63d0\u4f9b\u8005"}], "release": {"ref": "https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2", "label": "18.6", "major": "18", "channel": "stable", "revision": "555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f", "source_sha256": "555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f", "catalog_fingerprint": "65c93d6048ef30e61023a84f9680fa6a92b1c383b7eb226741170077eb078502"}, "sources": [{"url": "https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2", "label": "Matching PostgreSQL source archive", "sha256": "555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f"}, {"url": "https://pg.center/docs/18/collation.html#COLLATION-MANAGING-STANDARD", "path": "collation.html", "label": "PostgreSQL 18 English manual", "sha256": "c98cbca2b2235a896f7fe438a88a99b8d6b9d1f50bdb49fe2794e9982a50797f", "language": "en", "original_url": "/docs/18/collation.html#COLLATION-MANAGING-STANDARD"}], "sections": [], "signature": "", "attributes": {"collname": "pg_unicode_fast", "collctype": "_null_", "colllocale": "PG_UNICODE_FAST", "collcollate": "_null_", "collversion": "1", "collencoding": "6", "collicurules": "_null_", "collprovider": "b", "collisdeterministic": "t"}, "source_oid": "6411", "description": ["\u6309 Unicode \u7801\u70b9\u6392\u5e8f\uff0c\u91c7\u7528 Unicode \u5b57\u7b26\u8bed\u4e49"], "manual_html": "<div class=\"sect3\" id=\"COLLATION-MANAGING-STANDARD\">\n<div class=\"titlepage\">\n<div>\n<div>\n<h4 class=\"title\" lang=\"zh\">\n<div>\n<div>\n<h4 class=\"title\">23.2.2.1.\u00a0\u6807\u51c6\u6392\u5e8f\u89c4\u5219 </h4>\n</div>\n</div>\n</h4>\n</div>\n</div>\n</div>\n<p lang=\"zh\">\u5728\u6240\u6709\u5e73\u53f0\u4e0a\uff0c\u90fd\u652f\u6301\u4ee5\u4e0b\u6392\u5e8f\u89c4\u5219\uff1a</p>\n<div class=\"variablelist\">\n<dl class=\"variablelist\">\n<dt><span class=\"term\"><code class=\"literal\">unicode</code></span></dt>\n<dd>\n<p lang=\"zh\">\n<p>\u6b64 SQL \u6807\u51c6\u6392\u5e8f\u89c4\u5219\u4f7f\u7528 Unicode \u6392\u5e8f\u7b97\u6cd5\u548c\u9ed8\u8ba4 Unicode \u6392\u5e8f\u5143\u7d20\u8868\u8fdb\u884c\u6392\u5e8f\u3002\u5b83\u5728\u6240\u6709\u7f16\u7801\u4e2d\u90fd\u53ef\u7528\u3002\u4f7f\u7528\u6b64\u6392\u5e8f\u89c4\u5219\u9700\u8981 ICU \u652f\u6301\uff0c\u5e76\u4e14\u5982\u679c <span class=\"productname\">PostgreSQL</span>\u4f7f\u7528\u4e0d\u540c\u7248\u672c\u7684 ICU \u6784\u5efa\uff0c\u5176\u884c\u4e3a\u53ef\u80fd\u4f1a\u53d1\u751f\u53d8\u5316\u3002\uff08\u6b64\u6392\u5e8f\u89c4\u5219\u4e0e ICU \u6839\u533a\u57df\u8bbe\u7f6e\u5177\u6709\u76f8\u540c\u7684\u884c\u4e3a\uff1b\u53c2\u89c1<a class=\"xref\" href=\"/docs/18/collation.html#COLLATION-MANAGING-PREDEFINED-ICU-UND-X-ICU\"><code class=\"literal\">und-x-icu</code>\uff08\u8868\u793a<span class=\"quote\">\u201c<span class=\"quote\">\u672a\u5b9a\u4e49</span>\u201d</span>\uff09</a>\u3002\uff09</p>\n</p>\n</dd>\n<dt><span class=\"term\"><code class=\"literal\">ucs_basic</code></span></dt>\n<dd>\n<p lang=\"zh\">\u8fd9\u4e00 SQL \u6807\u51c6\u6392\u5e8f\u89c4\u5219\u6309 Unicode \u7801\u70b9\u503c\u6392\u5e8f\uff0c\u800c\u4e0d\u6309\u81ea\u7136\u8bed\u8a00\u987a\u5e8f\u6392\u5e8f\uff0c\u5e76\u4e14\u4ec5\u5c06 ASCII \u5b57\u6bcd A \u5230 Z \u89c6\u4e3a\u5b57\u6bcd\u3002\u5b83\u5728\u5404\u7248\u672c\u4e2d\u7684\u884c\u4e3a\u9ad8\u6548\u4e14\u7a33\u5b9a\uff0c\u4ec5\u9002\u7528\u4e8e UTF8 \u7f16\u7801\uff1b\u884c\u4e3a\u4e0e UTF8 \u7f16\u7801\u4e0b\u7684 libc \u533a\u57df\u8bbe\u7f6e C \u76f8\u540c\u3002</p>\n</dd>\n<dt><span class=\"term\"><code class=\"literal\">pg_unicode_fast</code></span></dt>\n<dd>\n<p lang=\"zh\">\n<p>\u6b64\u6392\u5e8f\u89c4\u5219\u6309 Unicode \u4ee3\u7801\u70b9\u503c\u800c\u4e0d\u662f\u81ea\u7136\u8bed\u8a00\u987a\u5e8f\u8fdb\u884c\u6392\u5e8f\u3002\u5bf9\u4e8e <code class=\"function\">lower</code>\u3001<code class=\"function\">initcap</code>\u548c <code class=\"function\">upper</code>\u51fd\u6570\uff0c\u5b83\u4f7f\u7528 Unicode \u5b8c\u6574\u5927\u5c0f\u5199\u6620\u5c04\u3002\u5bf9\u4e8e\u6a21\u5f0f\u5339\u914d\uff08\u5305\u62ec\u6b63\u5219\u8868\u8fbe\u5f0f\uff09\uff0c\u5b83\u4f7f\u7528 Unicode <a class=\"ulink\" href=\"https://www.unicode.org/reports/tr18/#Compatibility_Properties\" target=\"_top\">\u517c\u5bb9\u5c5e\u6027</a>\u7684\u6807\u51c6\u53d8\u4f53\u3002\u5176\u884c\u4e3a\u5728 <span class=\"productname\">Postgres</span>\u4e3b\u7248\u672c\u5185\u9ad8\u6548\u4e14\u7a33\u5b9a\u3002\u4ec5\u9002\u7528\u4e8e <code class=\"literal\">UTF8</code>\u7f16\u7801\u3002</p>\n</p>\n</dd>\n<dt><span class=\"term\"><code class=\"literal\">pg_c_utf8</code></span></dt>\n<dd>\n<p lang=\"zh\">\n<p>\u6b64\u6392\u5e8f\u89c4\u5219\u6309 Unicode \u4ee3\u7801\u70b9\u503c\u800c\u4e0d\u662f\u81ea\u7136\u8bed\u8a00\u987a\u5e8f\u8fdb\u884c\u6392\u5e8f\u3002\u5bf9\u4e8e <code class=\"function\">lower</code>\u3001<code class=\"function\">initcap</code>\u548c <code class=\"function\">upper</code>\u51fd\u6570\uff0c\u5b83\u4f7f\u7528 Unicode \u7b80\u5355\u5927\u5c0f\u5199\u6620\u5c04\u3002\u5bf9\u4e8e\u6a21\u5f0f\u5339\u914d\uff08\u5305\u62ec\u6b63\u5219\u8868\u8fbe\u5f0f\uff09\uff0c\u5b83\u4f7f\u7528 Unicode <a class=\"ulink\" href=\"https://www.unicode.org/reports/tr18/#Compatibility_Properties\" target=\"_top\">\u517c\u5bb9\u5c5e\u6027</a>\u7684 POSIX \u517c\u5bb9\u53d8\u4f53\u3002\u5176\u884c\u4e3a\u5728 <span class=\"productname\">PostgreSQL</span>\u4e3b\u7248\u672c\u5185\u9ad8\u6548\u4e14\u7a33\u5b9a\u3002\u6b64\u6392\u5e8f\u89c4\u5219\u4ec5\u9002\u7528\u4e8e<code class=\"literal\">UTF8</code>\u7f16\u7801\u3002</p>\n</p>\n</dd>\n<dt lang=\"zh\"><span class=\"term\"><code class=\"literal\">C</code>\uff08\u7b49\u540c\u4e8e<code class=\"literal\">POSIX</code>\uff09</span></dt>\n<dd>\n<p lang=\"zh\">\n<p><code class=\"literal\">C</code>\u548c<code class=\"literal\">POSIX</code>\u6392\u5e8f\u89c4\u5219\u57fa\u4e8e<span class=\"quote\">\u201c<span class=\"quote\">\u4f20\u7edf C</span>\u201d</span>\u884c\u4e3a\u3002\u5b83\u4eec\u6309\u5b57\u8282\u503c\u800c\u4e0d\u662f\u81ea\u7136\u8bed\u8a00\u987a\u5e8f\u6392\u5e8f\uff0c\u5e76\u4e14\u53ea\u6709 ASCII \u5b57\u6bcd<span class=\"quote\">\u201c<span class=\"quote\"><code class=\"literal\">A</code></span>\u201d</span>\u5230<span class=\"quote\">\u201c<span class=\"quote\"><code class=\"literal\">Z</code></span>\u201d</span>\u4f1a\u88ab\u89c6\u4e3a\u5b57\u6bcd\u3002\u5bf9\u4e8e\u7ed9\u5b9a\u7684\u6570\u636e\u5e93\u7f16\u7801\uff0c\u5176\u884c\u4e3a\u9ad8\u6548\u4e14\u5728\u6240\u6709\u7248\u672c\u4e2d\u90fd\u7a33\u5b9a\uff0c\u4f46\u5728\u4e0d\u540c\u6570\u636e\u5e93\u7f16\u7801\u4e4b\u95f4\u53ef\u80fd\u4f1a\u6709\u6240\u4e0d\u540c\u3002</p>\n</p>\n</dd>\n<dt lang=\"zh\">\u9ed8\u8ba4</dt>\n<dd>\n<p lang=\"zh\">\n<p><code class=\"literal\">default</code>\u6392\u5e8f\u89c4\u5219\u4f1a\u9009\u62e9\u6570\u636e\u5e93\u521b\u5efa\u65f6\u6307\u5b9a\u7684\u533a\u57df\u8bbe\u7f6e\u3002</p>\n</p>\n</dd>\n</dl>\n</div>\n<p lang=\"zh\">\u6839\u636e\u64cd\u4f5c\u7cfb\u7edf\u652f\u6301\u60c5\u51b5\uff0c\u8fd8\u53ef\u80fd\u5b58\u5728\u5176\u4ed6\u6392\u5e8f\u89c4\u5219\u3002\u8fd9\u4e9b\u9644\u52a0\u6392\u5e8f\u89c4\u5219\u7684\u6548\u7387\u548c\u7a33\u5b9a\u6027\u53d6\u51b3\u4e8e\u6392\u5e8f\u89c4\u5219\u63d0\u4f9b\u7a0b\u5e8f\u3001\u63d0\u4f9b\u7a0b\u5e8f\u7248\u672c\u4ee5\u53ca\u533a\u57df\u8bbe\u7f6e\u3002</p>\n</div>", "manual_path": "/docs/18/collation.html#COLLATION-MANAGING-STANDARD", "localization": {"status": "complete", "sources": [{"url": "/docs/18/collation.html", "method": "same-major semantic node", "sha256": "4fa99946c7c01ec3872b49a1fa92cadcd30d5a34d425829f836674d5c63b571a", "language": "zh", "matched_nodes": ["#COLLATION/div[4]/p[2]/span[0]/span[0]", "#COLLATION/div[5]/div[4]/div[0]", "#COLLATION/div[5]/div[4]/div[2]/dl[0]/dd[11]", "#COLLATION/div[5]/div[4]/div[2]/dl[0]/dd[1]", "#COLLATION/div[5]/div[4]/div[2]/dl[0]/dd[5]", "#COLLATION/div[5]/div[4]/div[2]/dl[0]/dd[7]", "#COLLATION/div[5]/div[4]/div[2]/dl[0]/dd[9]", "#COLLATION/div[5]/div[4]/div[2]/dl[0]/dt[8]", "#COLLATION/div[5]/div[4]/p[1]", "#COLLATION/div[5]/div[4]/p[3]"]}], "language": "zh", "original_text": {"/versions/18/description/0": "sorts by Unicode code point; Unicode character semantics", "/versions/18/facts/0/label": "Collisdeterministic", "/versions/18/facts/1/label": "Collcollate", "/versions/18/facts/2/label": "Collctype", "/versions/18/facts/3/label": "Colllocale", "/versions/18/facts/4/label": "Collicurules", "/versions/18/facts/5/label": "Collversion", "/versions/18/facts/6/label": "Collname", "/versions/18/facts/7/label": "Collprovider", "/versions/18/facts/8/label": "Collencoding", "/versions/18/related/0/label": "builtin provider"}, "fallback_fields": [], "source_language": "en", "original_snapshot_sha256": "76675ecf7af07367401bfacaa388ce95903c15e7a7487aa5cfa84913e4f8b2ff"}, "comparison_data": {"locale": "PG_UNICODE_FAST", "collname": "pg_unicode_fast", "collversion": "1", "collencoding": "6", "collprovider": "b", "collisdeterministic": "t"}, "comparison_hash": "6c14506a33a6e7605cd89dfe89b6382cf89a0d5a329b6dff5127220778617736", "manual_language": "zh"}, "19": {"facts": [{"label": "\u662f\u5426\u786e\u5b9a\u6027\u6bd4\u8f83\uff08collisdeterministic\uff09", "value": "t"}, {"label": "\u6392\u5e8f\u533a\u57df\u8bbe\u7f6e\uff08collcollate\uff09", "value": "_null_"}, {"label": "\u5b57\u7b26\u5206\u7c7b\u533a\u57df\u8bbe\u7f6e\uff08collctype\uff09", "value": "_null_"}, {"label": "\u533a\u57df\u8bbe\u7f6e\uff08colllocale\uff09", "value": "PG_UNICODE_FAST"}, {"label": "ICU \u89c4\u5219\uff08collicurules\uff09", "value": "_null_"}, {"label": "\u63d0\u4f9b\u8005\u7248\u672c\uff08collversion\uff09", "value": "1"}, {"label": "\u6392\u5e8f\u89c4\u5219\u540d\u79f0\uff08collname\uff09", "value": "pg_unicode_fast"}, {"label": "\u6392\u5e8f\u89c4\u5219\u63d0\u4f9b\u8005\uff08collprovider\uff09", "value": "b"}, {"label": "\u5b57\u7b26\u7f16\u7801\uff08collencoding\uff09", "value": "6"}], "tables": [], "aliases": [], "catalog": {"oid": "6411", "descr": "sorts by Unicode code point; Unicode character semantics", "collname": "pg_unicode_fast", "collctype": "_null_", "collowner": "POSTGRES", "colllocale": "PG_UNICODE_FAST", "collcollate": "_null_", "collversion": "1", "collencoding": "6", "collicurules": "_null_", "collprovider": "b", "collnamespace": "pg_catalog", "collisdeterministic": "t"}, "related": [{"url": "/wiki/locale/provider-builtin/?v=19", "label": "builtin \u63d0\u4f9b\u8005"}], "release": {"ref": "https://ftp.postgresql.org/pub/source/v19beta4/postgresql-19beta4.tar.bz2", "label": "19beta4", "major": "19", "channel": "preview", "revision": "83157ee9c599d03b2f7a3d73ef3a56ec24e0e79cc2b3501a64d1364f56398c86", "source_sha256": "83157ee9c599d03b2f7a3d73ef3a56ec24e0e79cc2b3501a64d1364f56398c86", "catalog_fingerprint": "62fbf1a3689dbe8bf7e6b3372cfe6fbf867581427b3858a94c8419b77a4d2d1d"}, "sources": [{"url": "https://ftp.postgresql.org/pub/source/v19beta4/postgresql-19beta4.tar.bz2", "label": "Matching PostgreSQL source archive", "sha256": "83157ee9c599d03b2f7a3d73ef3a56ec24e0e79cc2b3501a64d1364f56398c86"}, {"url": "https://pg.center/docs/19/collation.html#COLLATION-MANAGING-STANDARD", "path": "collation.html", "label": "PostgreSQL 19 English manual", "sha256": "2eef5fdde9bbc23617bb28de2a76a46c48b5a51662dc9212b1ceb56a85199a5e", "language": "en", "original_url": "/docs/19/collation.html#COLLATION-MANAGING-STANDARD"}], "sections": [], "signature": "", "attributes": {"collname": "pg_unicode_fast", "collctype": "_null_", "colllocale": "PG_UNICODE_FAST", "collcollate": "_null_", "collversion": "1", "collencoding": "6", "collicurules": "_null_", "collprovider": "b", "collisdeterministic": "t"}, "source_oid": "6411", "description": ["\u6309 Unicode \u7801\u70b9\u6392\u5e8f\uff0c\u91c7\u7528 Unicode \u5b57\u7b26\u8bed\u4e49"], "manual_html": "<div class=\"sect3\" id=\"COLLATION-MANAGING-STANDARD\">\n<div class=\"titlepage\">\n<div>\n<div>\n<h4 class=\"title\" lang=\"zh\">\n<div>\n<div>\n<h4 class=\"title\">23.2.2.1.\u00a0\u6807\u51c6\u6392\u5e8f\u89c4\u5219 </h4>\n</div>\n</div>\n</h4>\n</div>\n</div>\n</div>\n<p lang=\"zh\">\u5728\u6240\u6709\u5e73\u53f0\u4e0a\uff0c\u90fd\u652f\u6301\u4ee5\u4e0b\u6392\u5e8f\u89c4\u5219\uff1a</p>\n<div class=\"variablelist\">\n<dl class=\"variablelist\">\n<dt><span class=\"term\"><code class=\"literal\">unicode</code></span></dt>\n<dd>\n<p lang=\"zh\">\n<p>\u6b64 SQL \u6807\u51c6\u6392\u5e8f\u89c4\u5219\u4f7f\u7528 Unicode \u6392\u5e8f\u7b97\u6cd5\u548c\u9ed8\u8ba4 Unicode \u6392\u5e8f\u5143\u7d20\u8868\u8fdb\u884c\u6392\u5e8f\u3002\u5b83\u5728\u6240\u6709\u7f16\u7801\u4e2d\u90fd\u53ef\u7528\u3002\u4f7f\u7528\u6b64\u6392\u5e8f\u89c4\u5219\u9700\u8981 ICU \u652f\u6301\uff0c\u5e76\u4e14\u5982\u679c <span class=\"productname\">PostgreSQL</span>\u4f7f\u7528\u4e0d\u540c\u7248\u672c\u7684 ICU \u6784\u5efa\uff0c\u5176\u884c\u4e3a\u53ef\u80fd\u4f1a\u53d1\u751f\u53d8\u5316\u3002\uff08\u6b64\u6392\u5e8f\u89c4\u5219\u4e0e ICU \u6839\u533a\u57df\u8bbe\u7f6e\u5177\u6709\u76f8\u540c\u7684\u884c\u4e3a\uff1b\u53c2\u89c1<a class=\"xref\" href=\"/docs/19/collation.html#COLLATION-MANAGING-PREDEFINED-ICU-UND-X-ICU\"><code class=\"literal\">und-x-icu</code>\uff08\u8868\u793a<span class=\"quote\">\u201c<span class=\"quote\">\u672a\u5b9a\u4e49</span>\u201d</span>\uff09</a>\u3002\uff09</p>\n</p>\n</dd>\n<dt><span class=\"term\"><code class=\"literal\">ucs_basic</code></span></dt>\n<dd>\n<p lang=\"zh\">\u8fd9\u4e00 SQL \u6807\u51c6\u6392\u5e8f\u89c4\u5219\u6309 Unicode \u7801\u70b9\u503c\u6392\u5e8f\uff0c\u800c\u4e0d\u6309\u81ea\u7136\u8bed\u8a00\u987a\u5e8f\u6392\u5e8f\uff0c\u5e76\u4e14\u4ec5\u5c06 ASCII \u5b57\u6bcd A \u5230 Z \u89c6\u4e3a\u5b57\u6bcd\u3002\u5b83\u5728\u5404\u7248\u672c\u4e2d\u7684\u884c\u4e3a\u9ad8\u6548\u4e14\u7a33\u5b9a\uff0c\u4ec5\u9002\u7528\u4e8e UTF8 \u7f16\u7801\uff1b\u884c\u4e3a\u4e0e UTF8 \u7f16\u7801\u4e0b\u7684 libc \u533a\u57df\u8bbe\u7f6e C \u76f8\u540c\u3002</p>\n</dd>\n<dt><span class=\"term\"><code class=\"literal\">pg_unicode_fast</code></span></dt>\n<dd>\n<p lang=\"zh\">\n<p>\u6b64\u6392\u5e8f\u89c4\u5219\u6309 Unicode \u4ee3\u7801\u70b9\u503c\u800c\u4e0d\u662f\u81ea\u7136\u8bed\u8a00\u987a\u5e8f\u8fdb\u884c\u6392\u5e8f\u3002\u5bf9\u4e8e <code class=\"function\">lower</code>\u3001<code class=\"function\">initcap</code>\u548c <code class=\"function\">upper</code>\u51fd\u6570\uff0c\u5b83\u4f7f\u7528 Unicode \u5b8c\u6574\u5927\u5c0f\u5199\u6620\u5c04\u3002\u5bf9\u4e8e\u6a21\u5f0f\u5339\u914d\uff08\u5305\u62ec\u6b63\u5219\u8868\u8fbe\u5f0f\uff09\uff0c\u5b83\u4f7f\u7528 Unicode <a class=\"ulink\" href=\"https://www.unicode.org/reports/tr18/#Compatibility_Properties\" target=\"_top\">\u517c\u5bb9\u5c5e\u6027</a>\u7684\u6807\u51c6\u53d8\u4f53\u3002\u5176\u884c\u4e3a\u5728 <span class=\"productname\">Postgres</span>\u4e3b\u7248\u672c\u5185\u9ad8\u6548\u4e14\u7a33\u5b9a\u3002\u4ec5\u9002\u7528\u4e8e <code class=\"literal\">UTF8</code>\u7f16\u7801\u3002</p>\n</p>\n</dd>\n<dt><span class=\"term\"><code class=\"literal\">pg_c_utf8</code></span></dt>\n<dd>\n<p lang=\"zh\">\n<p>\u6b64\u6392\u5e8f\u89c4\u5219\u6309 Unicode \u4ee3\u7801\u70b9\u503c\u800c\u4e0d\u662f\u81ea\u7136\u8bed\u8a00\u987a\u5e8f\u8fdb\u884c\u6392\u5e8f\u3002\u5bf9\u4e8e <code class=\"function\">lower</code>\u3001<code class=\"function\">initcap</code>\u548c <code class=\"function\">upper</code>\u51fd\u6570\uff0c\u5b83\u4f7f\u7528 Unicode \u7b80\u5355\u5927\u5c0f\u5199\u6620\u5c04\u3002\u5bf9\u4e8e\u6a21\u5f0f\u5339\u914d\uff08\u5305\u62ec\u6b63\u5219\u8868\u8fbe\u5f0f\uff09\uff0c\u5b83\u4f7f\u7528 Unicode <a class=\"ulink\" href=\"https://www.unicode.org/reports/tr18/#Compatibility_Properties\" target=\"_top\">\u517c\u5bb9\u5c5e\u6027</a>\u7684 POSIX \u517c\u5bb9\u53d8\u4f53\u3002\u5176\u884c\u4e3a\u5728 <span class=\"productname\">PostgreSQL</span>\u4e3b\u7248\u672c\u5185\u9ad8\u6548\u4e14\u7a33\u5b9a\u3002\u6b64\u6392\u5e8f\u89c4\u5219\u4ec5\u9002\u7528\u4e8e<code class=\"literal\">UTF8</code>\u7f16\u7801\u3002</p>\n</p>\n</dd>\n<dt lang=\"zh\"><span class=\"term\"><code class=\"literal\">C</code>\uff08\u7b49\u540c\u4e8e<code class=\"literal\">POSIX</code>\uff09</span></dt>\n<dd>\n<p lang=\"zh\">\n<p><code class=\"literal\">C</code>\u548c<code class=\"literal\">POSIX</code>\u6392\u5e8f\u89c4\u5219\u57fa\u4e8e<span class=\"quote\">\u201c<span class=\"quote\">\u4f20\u7edf C</span>\u201d</span>\u884c\u4e3a\u3002\u5b83\u4eec\u6309\u5b57\u8282\u503c\u800c\u4e0d\u662f\u81ea\u7136\u8bed\u8a00\u987a\u5e8f\u6392\u5e8f\uff0c\u5e76\u4e14\u53ea\u6709 ASCII \u5b57\u6bcd<span class=\"quote\">\u201c<span class=\"quote\"><code class=\"literal\">A</code></span>\u201d</span>\u5230<span class=\"quote\">\u201c<span class=\"quote\"><code class=\"literal\">Z</code></span>\u201d</span>\u4f1a\u88ab\u89c6\u4e3a\u5b57\u6bcd\u3002\u5bf9\u4e8e\u7ed9\u5b9a\u7684\u6570\u636e\u5e93\u7f16\u7801\uff0c\u5176\u884c\u4e3a\u9ad8\u6548\u4e14\u5728\u6240\u6709\u7248\u672c\u4e2d\u90fd\u7a33\u5b9a\uff0c\u4f46\u5728\u4e0d\u540c\u6570\u636e\u5e93\u7f16\u7801\u4e4b\u95f4\u53ef\u80fd\u4f1a\u6709\u6240\u4e0d\u540c\u3002</p>\n</p>\n</dd>\n<dt lang=\"zh\">\u9ed8\u8ba4</dt>\n<dd>\n<p lang=\"zh\">\n<p><code class=\"literal\">default</code>\u6392\u5e8f\u89c4\u5219\u4f1a\u9009\u62e9\u6570\u636e\u5e93\u521b\u5efa\u65f6\u6307\u5b9a\u7684\u533a\u57df\u8bbe\u7f6e\u3002</p>\n</p>\n</dd>\n</dl>\n</div>\n<p lang=\"zh\">\u6839\u636e\u64cd\u4f5c\u7cfb\u7edf\u652f\u6301\u60c5\u51b5\uff0c\u8fd8\u53ef\u80fd\u5b58\u5728\u5176\u4ed6\u6392\u5e8f\u89c4\u5219\u3002\u8fd9\u4e9b\u9644\u52a0\u6392\u5e8f\u89c4\u5219\u7684\u6548\u7387\u548c\u7a33\u5b9a\u6027\u53d6\u51b3\u4e8e\u6392\u5e8f\u89c4\u5219\u63d0\u4f9b\u7a0b\u5e8f\u3001\u63d0\u4f9b\u7a0b\u5e8f\u7248\u672c\u4ee5\u53ca\u533a\u57df\u8bbe\u7f6e\u3002</p>\n</div>", "manual_path": "/docs/19/collation.html#COLLATION-MANAGING-STANDARD", "localization": {"status": "complete", "sources": [{"url": "/docs/19/collation.html", "method": "same-major semantic node", "sha256": "5f52d911c49ada8ebaf89c3bb635ee3e1065f3d39e9942830b32a92560bfba57", "language": "zh", "matched_nodes": ["#COLLATION/div[4]/p[2]/span[0]/span[0]", "#COLLATION/div[5]/div[4]/div[0]", "#COLLATION/div[5]/div[4]/div[2]/dl[0]/dd[11]", "#COLLATION/div[5]/div[4]/div[2]/dl[0]/dd[1]", "#COLLATION/div[5]/div[4]/div[2]/dl[0]/dd[5]", "#COLLATION/div[5]/div[4]/div[2]/dl[0]/dd[7]", "#COLLATION/div[5]/div[4]/div[2]/dl[0]/dd[9]", "#COLLATION/div[5]/div[4]/div[2]/dl[0]/dt[8]", "#COLLATION/div[5]/div[4]/p[1]", "#COLLATION/div[5]/div[4]/p[3]"]}], "language": "zh", "original_text": {"/versions/19/description/0": "sorts by Unicode code point; Unicode character semantics", "/versions/19/facts/0/label": "Collisdeterministic", "/versions/19/facts/1/label": "Collcollate", "/versions/19/facts/2/label": "Collctype", "/versions/19/facts/3/label": "Colllocale", "/versions/19/facts/4/label": "Collicurules", "/versions/19/facts/5/label": "Collversion", "/versions/19/facts/6/label": "Collname", "/versions/19/facts/7/label": "Collprovider", "/versions/19/facts/8/label": "Collencoding", "/versions/19/related/0/label": "builtin provider"}, "fallback_fields": [], "source_language": "en", "original_snapshot_sha256": "d2f5ddea07cdf657ab98d49ba7ee04cd1bc5c56d13797a19269cbe785712457f"}, "comparison_data": {"locale": "PG_UNICODE_FAST", "collname": "pg_unicode_fast", "collversion": "1", "collencoding": "6", "collprovider": "b", "collisdeterministic": "t"}, "comparison_hash": "6c14506a33a6e7605cd89dfe89b6382cf89a0d5a329b6dff5127220778617736", "manual_language": "zh"}, "20": {"facts": [{"label": "\u662f\u5426\u786e\u5b9a\u6027\u6bd4\u8f83\uff08collisdeterministic\uff09", "value": "t"}, {"label": "\u6392\u5e8f\u533a\u57df\u8bbe\u7f6e\uff08collcollate\uff09", "value": "_null_"}, {"label": "\u5b57\u7b26\u5206\u7c7b\u533a\u57df\u8bbe\u7f6e\uff08collctype\uff09", "value": "_null_"}, {"label": "\u533a\u57df\u8bbe\u7f6e\uff08colllocale\uff09", "value": "PG_UNICODE_FAST"}, {"label": "ICU \u89c4\u5219\uff08collicurules\uff09", "value": "_null_"}, {"label": "\u63d0\u4f9b\u8005\u7248\u672c\uff08collversion\uff09", "value": "1"}, {"label": "\u6392\u5e8f\u89c4\u5219\u540d\u79f0\uff08collname\uff09", "value": "pg_unicode_fast"}, {"label": "\u6392\u5e8f\u89c4\u5219\u63d0\u4f9b\u8005\uff08collprovider\uff09", "value": "b"}, {"label": "\u5b57\u7b26\u7f16\u7801\uff08collencoding\uff09", "value": "6"}], "tables": [], "aliases": [], "catalog": {"oid": "6411", "descr": "sorts by Unicode code point; Unicode character semantics", "collname": "pg_unicode_fast", "collctype": "_null_", "collowner": "POSTGRES", "colllocale": "PG_UNICODE_FAST", "collcollate": "_null_", "collversion": "1", "collencoding": "6", "collicurules": "_null_", "collprovider": "b", "collnamespace": "pg_catalog", "collisdeterministic": "t"}, "related": [{"url": "/wiki/locale/provider-builtin/?v=20", "label": "builtin \u63d0\u4f9b\u8005"}], "release": {"ref": "https://ftp.postgresql.org/pub/snapshot/dev/postgresql-snapshot.tar.bz2", "label": "20devel", "major": "20", "channel": "devel", "revision": "4d3346909b201ac1648232cf290462a7070c119326f56196f1f0253ed80fae41", "source_sha256": "4d3346909b201ac1648232cf290462a7070c119326f56196f1f0253ed80fae41", "catalog_fingerprint": "398fbb9f262264053c02fbf79f88be0a6770c1473faa6ecd5931d6ec41b8258b", "source_snapshot_utc": "26-Sep-2026 20:22"}, "sources": [{"url": "https://ftp.postgresql.org/pub/snapshot/dev/postgresql-snapshot.tar.bz2", "label": "Matching PostgreSQL source archive", "sha256": "4d3346909b201ac1648232cf290462a7070c119326f56196f1f0253ed80fae41"}, {"url": "https://pg.center/docs/devel/collation.html#COLLATION-MANAGING-STANDARD", "path": "collation.html", "label": "PostgreSQL 20 English manual", "sha256": "3a5f2e6c1df8548d2a7d1f654dfc8fe598c1ce90f62169c3a2d11d8c736f940e", "language": "en", "original_url": "/docs/devel/collation.html#COLLATION-MANAGING-STANDARD"}], "sections": [], "signature": "", "attributes": {"collname": "pg_unicode_fast", "collctype": "_null_", "colllocale": "PG_UNICODE_FAST", "collcollate": "_null_", "collversion": "1", "collencoding": "6", "collicurules": "_null_", "collprovider": "b", "collisdeterministic": "t"}, "source_oid": "6411", "description": ["\u6309 Unicode \u7801\u70b9\u6392\u5e8f\uff0c\u91c7\u7528 Unicode \u5b57\u7b26\u8bed\u4e49"], "manual_html": "<div class=\"sect3\" id=\"COLLATION-MANAGING-STANDARD\">\n<div class=\"titlepage\">\n<div>\n<div>\n<h4 class=\"title\" lang=\"zh\">\n<div>\n<div>\n<h4 class=\"title\">23.2.2.1.\u00a0\u6807\u51c6\u6392\u5e8f\u89c4\u5219 </h4>\n</div>\n</div>\n</h4>\n</div>\n</div>\n</div>\n<p lang=\"zh\">\u5728\u6240\u6709\u5e73\u53f0\u4e0a\uff0c\u90fd\u652f\u6301\u4ee5\u4e0b\u6392\u5e8f\u89c4\u5219\uff1a</p>\n<div class=\"variablelist\">\n<dl class=\"variablelist\">\n<dt><span class=\"term\"><code class=\"literal\">unicode</code></span></dt>\n<dd>\n<p lang=\"zh\">\n<p>\u6b64 SQL \u6807\u51c6\u6392\u5e8f\u89c4\u5219\u4f7f\u7528 Unicode \u6392\u5e8f\u7b97\u6cd5\u548c\u9ed8\u8ba4 Unicode \u6392\u5e8f\u5143\u7d20\u8868\u8fdb\u884c\u6392\u5e8f\u3002\u5b83\u5728\u6240\u6709\u7f16\u7801\u4e2d\u90fd\u53ef\u7528\u3002\u4f7f\u7528\u6b64\u6392\u5e8f\u89c4\u5219\u9700\u8981 ICU \u652f\u6301\uff0c\u5e76\u4e14\u5982\u679c <span class=\"productname\">PostgreSQL</span>\u4f7f\u7528\u4e0d\u540c\u7248\u672c\u7684 ICU \u6784\u5efa\uff0c\u5176\u884c\u4e3a\u53ef\u80fd\u4f1a\u53d1\u751f\u53d8\u5316\u3002\uff08\u6b64\u6392\u5e8f\u89c4\u5219\u4e0e ICU \u6839\u533a\u57df\u8bbe\u7f6e\u5177\u6709\u76f8\u540c\u7684\u884c\u4e3a\uff1b\u53c2\u89c1<a class=\"xref\" href=\"/docs/devel/collation.html#COLLATION-MANAGING-PREDEFINED-ICU-UND-X-ICU\"><code class=\"literal\">und-x-icu</code>\uff08\u8868\u793a<span class=\"quote\">\u201c<span class=\"quote\">\u672a\u5b9a\u4e49</span>\u201d</span>\uff09</a>\u3002\uff09</p>\n</p>\n</dd>\n<dt><span class=\"term\"><code class=\"literal\">ucs_basic</code></span></dt>\n<dd>\n<p lang=\"zh\">\u8fd9\u4e00 SQL \u6807\u51c6\u6392\u5e8f\u89c4\u5219\u6309 Unicode \u7801\u70b9\u503c\u6392\u5e8f\uff0c\u800c\u4e0d\u6309\u81ea\u7136\u8bed\u8a00\u987a\u5e8f\u6392\u5e8f\uff0c\u5e76\u4e14\u4ec5\u5c06 ASCII \u5b57\u6bcd A \u5230 Z \u89c6\u4e3a\u5b57\u6bcd\u3002\u5b83\u5728\u5404\u7248\u672c\u4e2d\u7684\u884c\u4e3a\u9ad8\u6548\u4e14\u7a33\u5b9a\uff0c\u4ec5\u9002\u7528\u4e8e UTF8 \u7f16\u7801\uff1b\u884c\u4e3a\u4e0e UTF8 \u7f16\u7801\u4e0b\u7684 libc \u533a\u57df\u8bbe\u7f6e C \u76f8\u540c\u3002</p>\n</dd>\n<dt><span class=\"term\"><code class=\"literal\">pg_unicode_fast</code></span></dt>\n<dd>\n<p lang=\"zh\">\n<p>\u6b64\u6392\u5e8f\u89c4\u5219\u6309 Unicode \u4ee3\u7801\u70b9\u503c\u800c\u4e0d\u662f\u81ea\u7136\u8bed\u8a00\u987a\u5e8f\u8fdb\u884c\u6392\u5e8f\u3002\u5bf9\u4e8e <code class=\"function\">lower</code>\u3001<code class=\"function\">initcap</code>\u548c <code class=\"function\">upper</code>\u51fd\u6570\uff0c\u5b83\u4f7f\u7528 Unicode \u5b8c\u6574\u5927\u5c0f\u5199\u6620\u5c04\u3002\u5bf9\u4e8e\u6a21\u5f0f\u5339\u914d\uff08\u5305\u62ec\u6b63\u5219\u8868\u8fbe\u5f0f\uff09\uff0c\u5b83\u4f7f\u7528 Unicode <a class=\"ulink\" href=\"https://www.unicode.org/reports/tr18/#Compatibility_Properties\" target=\"_top\">\u517c\u5bb9\u5c5e\u6027</a>\u7684\u6807\u51c6\u53d8\u4f53\u3002\u5176\u884c\u4e3a\u5728 <span class=\"productname\">Postgres</span>\u4e3b\u7248\u672c\u5185\u9ad8\u6548\u4e14\u7a33\u5b9a\u3002\u4ec5\u9002\u7528\u4e8e <code class=\"literal\">UTF8</code>\u7f16\u7801\u3002</p>\n</p>\n</dd>\n<dt><span class=\"term\"><code class=\"literal\">pg_c_utf8</code></span></dt>\n<dd>\n<p lang=\"zh\">\n<p>\u6b64\u6392\u5e8f\u89c4\u5219\u6309 Unicode \u4ee3\u7801\u70b9\u503c\u800c\u4e0d\u662f\u81ea\u7136\u8bed\u8a00\u987a\u5e8f\u8fdb\u884c\u6392\u5e8f\u3002\u5bf9\u4e8e <code class=\"function\">lower</code>\u3001<code class=\"function\">initcap</code>\u548c <code class=\"function\">upper</code>\u51fd\u6570\uff0c\u5b83\u4f7f\u7528 Unicode \u7b80\u5355\u5927\u5c0f\u5199\u6620\u5c04\u3002\u5bf9\u4e8e\u6a21\u5f0f\u5339\u914d\uff08\u5305\u62ec\u6b63\u5219\u8868\u8fbe\u5f0f\uff09\uff0c\u5b83\u4f7f\u7528 Unicode <a class=\"ulink\" href=\"https://www.unicode.org/reports/tr18/#Compatibility_Properties\" target=\"_top\">\u517c\u5bb9\u5c5e\u6027</a>\u7684 POSIX \u517c\u5bb9\u53d8\u4f53\u3002\u5176\u884c\u4e3a\u5728 <span class=\"productname\">PostgreSQL</span>\u4e3b\u7248\u672c\u5185\u9ad8\u6548\u4e14\u7a33\u5b9a\u3002\u6b64\u6392\u5e8f\u89c4\u5219\u4ec5\u9002\u7528\u4e8e<code class=\"literal\">UTF8</code>\u7f16\u7801\u3002</p>\n</p>\n</dd>\n<dt lang=\"zh\"><span class=\"term\"><code class=\"literal\">C</code>\uff08\u7b49\u540c\u4e8e<code class=\"literal\">POSIX</code>\uff09</span></dt>\n<dd>\n<p lang=\"zh\">\n<p><code class=\"literal\">C</code>\u548c<code class=\"literal\">POSIX</code>\u6392\u5e8f\u89c4\u5219\u57fa\u4e8e<span class=\"quote\">\u201c<span class=\"quote\">\u4f20\u7edf C</span>\u201d</span>\u884c\u4e3a\u3002\u5b83\u4eec\u6309\u5b57\u8282\u503c\u800c\u4e0d\u662f\u81ea\u7136\u8bed\u8a00\u987a\u5e8f\u6392\u5e8f\uff0c\u5e76\u4e14\u53ea\u6709 ASCII \u5b57\u6bcd<span class=\"quote\">\u201c<span class=\"quote\"><code class=\"literal\">A</code></span>\u201d</span>\u5230<span class=\"quote\">\u201c<span class=\"quote\"><code class=\"literal\">Z</code></span>\u201d</span>\u4f1a\u88ab\u89c6\u4e3a\u5b57\u6bcd\u3002\u5bf9\u4e8e\u7ed9\u5b9a\u7684\u6570\u636e\u5e93\u7f16\u7801\uff0c\u5176\u884c\u4e3a\u9ad8\u6548\u4e14\u5728\u6240\u6709\u7248\u672c\u4e2d\u90fd\u7a33\u5b9a\uff0c\u4f46\u5728\u4e0d\u540c\u6570\u636e\u5e93\u7f16\u7801\u4e4b\u95f4\u53ef\u80fd\u4f1a\u6709\u6240\u4e0d\u540c\u3002</p>\n</p>\n</dd>\n<dt lang=\"zh\">\u9ed8\u8ba4</dt>\n<dd>\n<p lang=\"zh\">\n<p><code class=\"literal\">default</code>\u6392\u5e8f\u89c4\u5219\u4f1a\u9009\u62e9\u6570\u636e\u5e93\u521b\u5efa\u65f6\u6307\u5b9a\u7684\u533a\u57df\u8bbe\u7f6e\u3002</p>\n</p>\n</dd>\n</dl>\n</div>\n<p lang=\"zh\">\u6839\u636e\u64cd\u4f5c\u7cfb\u7edf\u652f\u6301\u60c5\u51b5\uff0c\u8fd8\u53ef\u80fd\u5b58\u5728\u5176\u4ed6\u6392\u5e8f\u89c4\u5219\u3002\u8fd9\u4e9b\u9644\u52a0\u6392\u5e8f\u89c4\u5219\u7684\u6548\u7387\u548c\u7a33\u5b9a\u6027\u53d6\u51b3\u4e8e\u6392\u5e8f\u89c4\u5219\u63d0\u4f9b\u7a0b\u5e8f\u3001\u63d0\u4f9b\u7a0b\u5e8f\u7248\u672c\u4ee5\u53ca\u533a\u57df\u8bbe\u7f6e\u3002</p>\n</div>", "manual_path": "/docs/devel/collation.html#COLLATION-MANAGING-STANDARD", "localization": {"status": "complete", "sources": [{"url": "/docs/devel/collation.html", "method": "same-major semantic node", "sha256": "55649394e879869166c4d26a543faff79a871cab35978fb0ff4635557151714a", "language": "zh", "matched_nodes": ["#COLLATION/div[4]/p[2]/span[0]/span[0]", "#COLLATION/div[5]/div[4]/div[0]", "#COLLATION/div[5]/div[4]/div[2]/dl[0]/dd[11]", "#COLLATION/div[5]/div[4]/div[2]/dl[0]/dd[1]", "#COLLATION/div[5]/div[4]/div[2]/dl[0]/dd[5]", "#COLLATION/div[5]/div[4]/div[2]/dl[0]/dd[7]", "#COLLATION/div[5]/div[4]/div[2]/dl[0]/dd[9]", "#COLLATION/div[5]/div[4]/div[2]/dl[0]/dt[8]", "#COLLATION/div[5]/div[4]/p[1]", "#COLLATION/div[5]/div[4]/p[3]"]}], "language": "zh", "original_text": {"/summary": "sorts by Unicode code point; Unicode character semantics", "/category": "Bootstrap collations", "/versions/20/description/0": "sorts by Unicode code point; Unicode character semantics", "/versions/20/facts/0/label": "Collisdeterministic", "/versions/20/facts/1/label": "Collcollate", "/versions/20/facts/2/label": "Collctype", "/versions/20/facts/3/label": "Colllocale", "/versions/20/facts/4/label": "Collicurules", "/versions/20/facts/5/label": "Collversion", "/versions/20/facts/6/label": "Collname", "/versions/20/facts/7/label": "Collprovider", "/versions/20/facts/8/label": "Collencoding", "/versions/20/related/0/label": "builtin provider"}, "fallback_fields": [], "source_language": "en", "original_snapshot_sha256": "d23ce172931baa3f6bd22aaa5cbd5042a67a139444fb806524c6499b75d7c849"}, "comparison_data": {"locale": "PG_UNICODE_FAST", "collname": "pg_unicode_fast", "collversion": "1", "collencoding": "6", "collprovider": "b", "collisdeterministic": "t"}, "comparison_hash": "6c14506a33a6e7605cd89dfe89b6382cf89a0d5a329b6dff5127220778617736", "manual_language": "zh"}}}, "snapshot": {"facts": [{"label": "\u662f\u5426\u786e\u5b9a\u6027\u6bd4\u8f83\uff08collisdeterministic\uff09", "value": "t"}, {"label": "\u6392\u5e8f\u533a\u57df\u8bbe\u7f6e\uff08collcollate\uff09", "value": "_null_"}, {"label": "\u5b57\u7b26\u5206\u7c7b\u533a\u57df\u8bbe\u7f6e\uff08collctype\uff09", "value": "_null_"}, {"label": "\u533a\u57df\u8bbe\u7f6e\uff08colllocale\uff09", "value": "PG_UNICODE_FAST"}, {"label": "ICU \u89c4\u5219\uff08collicurules\uff09", "value": "_null_"}, {"label": "\u63d0\u4f9b\u8005\u7248\u672c\uff08collversion\uff09", "value": "1"}, {"label": "\u6392\u5e8f\u89c4\u5219\u540d\u79f0\uff08collname\uff09", "value": "pg_unicode_fast"}, {"label": "\u6392\u5e8f\u89c4\u5219\u63d0\u4f9b\u8005\uff08collprovider\uff09", "value": "b"}, {"label": "\u5b57\u7b26\u7f16\u7801\uff08collencoding\uff09", "value": "6"}], "tables": [], "aliases": [], "catalog": {"oid": "6411", "descr": "sorts by Unicode code point; Unicode character semantics", "collname": "pg_unicode_fast", "collctype": "_null_", "collowner": "POSTGRES", "colllocale": "PG_UNICODE_FAST", "collcollate": "_null_", "collversion": "1", "collencoding": "6", "collicurules": "_null_", "collprovider": "b", "collnamespace": "pg_catalog", "collisdeterministic": "t"}, "related": [{"url": "/wiki/locale/provider-builtin/?v=18", "label": "builtin \u63d0\u4f9b\u8005"}], "release": {"ref": "https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2", "label": "18.6", "major": "18", "channel": "stable", "revision": "555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f", "source_sha256": "555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f", "catalog_fingerprint": "65c93d6048ef30e61023a84f9680fa6a92b1c383b7eb226741170077eb078502"}, "sources": [{"url": "https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2", "label": "Matching PostgreSQL source archive", "sha256": "555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f"}, {"url": "https://pg.center/docs/18/collation.html#COLLATION-MANAGING-STANDARD", "path": "collation.html", "label": "PostgreSQL 18 English manual", "sha256": "c98cbca2b2235a896f7fe438a88a99b8d6b9d1f50bdb49fe2794e9982a50797f", "language": "en", "original_url": "/docs/18/collation.html#COLLATION-MANAGING-STANDARD"}], "sections": [], "signature": "", "attributes": {"collname": "pg_unicode_fast", "collctype": "_null_", "colllocale": "PG_UNICODE_FAST", "collcollate": "_null_", "collversion": "1", "collencoding": "6", "collicurules": "_null_", "collprovider": "b", "collisdeterministic": "t"}, "source_oid": "6411", "description": ["\u6309 Unicode \u7801\u70b9\u6392\u5e8f\uff0c\u91c7\u7528 Unicode \u5b57\u7b26\u8bed\u4e49"], "manual_html": "<div class=\"sect3\" id=\"COLLATION-MANAGING-STANDARD\">\n<div class=\"titlepage\">\n<div>\n<div>\n<h4 class=\"title\" lang=\"zh\">\n<div>\n<div>\n<h4 class=\"title\">23.2.2.1.\u00a0\u6807\u51c6\u6392\u5e8f\u89c4\u5219 </h4>\n</div>\n</div>\n</h4>\n</div>\n</div>\n</div>\n<p lang=\"zh\">\u5728\u6240\u6709\u5e73\u53f0\u4e0a\uff0c\u90fd\u652f\u6301\u4ee5\u4e0b\u6392\u5e8f\u89c4\u5219\uff1a</p>\n<div class=\"variablelist\">\n<dl class=\"variablelist\">\n<dt><span class=\"term\"><code class=\"literal\">unicode</code></span></dt>\n<dd>\n<p lang=\"zh\">\n<p>\u6b64 SQL \u6807\u51c6\u6392\u5e8f\u89c4\u5219\u4f7f\u7528 Unicode \u6392\u5e8f\u7b97\u6cd5\u548c\u9ed8\u8ba4 Unicode \u6392\u5e8f\u5143\u7d20\u8868\u8fdb\u884c\u6392\u5e8f\u3002\u5b83\u5728\u6240\u6709\u7f16\u7801\u4e2d\u90fd\u53ef\u7528\u3002\u4f7f\u7528\u6b64\u6392\u5e8f\u89c4\u5219\u9700\u8981 ICU \u652f\u6301\uff0c\u5e76\u4e14\u5982\u679c <span class=\"productname\">PostgreSQL</span>\u4f7f\u7528\u4e0d\u540c\u7248\u672c\u7684 ICU \u6784\u5efa\uff0c\u5176\u884c\u4e3a\u53ef\u80fd\u4f1a\u53d1\u751f\u53d8\u5316\u3002\uff08\u6b64\u6392\u5e8f\u89c4\u5219\u4e0e ICU \u6839\u533a\u57df\u8bbe\u7f6e\u5177\u6709\u76f8\u540c\u7684\u884c\u4e3a\uff1b\u53c2\u89c1<a class=\"xref\" href=\"/docs/18/collation.html#COLLATION-MANAGING-PREDEFINED-ICU-UND-X-ICU\"><code class=\"literal\">und-x-icu</code>\uff08\u8868\u793a<span class=\"quote\">\u201c<span class=\"quote\">\u672a\u5b9a\u4e49</span>\u201d</span>\uff09</a>\u3002\uff09</p>\n</p>\n</dd>\n<dt><span class=\"term\"><code class=\"literal\">ucs_basic</code></span></dt>\n<dd>\n<p lang=\"zh\">\u8fd9\u4e00 SQL \u6807\u51c6\u6392\u5e8f\u89c4\u5219\u6309 Unicode \u7801\u70b9\u503c\u6392\u5e8f\uff0c\u800c\u4e0d\u6309\u81ea\u7136\u8bed\u8a00\u987a\u5e8f\u6392\u5e8f\uff0c\u5e76\u4e14\u4ec5\u5c06 ASCII \u5b57\u6bcd A \u5230 Z \u89c6\u4e3a\u5b57\u6bcd\u3002\u5b83\u5728\u5404\u7248\u672c\u4e2d\u7684\u884c\u4e3a\u9ad8\u6548\u4e14\u7a33\u5b9a\uff0c\u4ec5\u9002\u7528\u4e8e UTF8 \u7f16\u7801\uff1b\u884c\u4e3a\u4e0e UTF8 \u7f16\u7801\u4e0b\u7684 libc \u533a\u57df\u8bbe\u7f6e C \u76f8\u540c\u3002</p>\n</dd>\n<dt><span class=\"term\"><code class=\"literal\">pg_unicode_fast</code></span></dt>\n<dd>\n<p lang=\"zh\">\n<p>\u6b64\u6392\u5e8f\u89c4\u5219\u6309 Unicode \u4ee3\u7801\u70b9\u503c\u800c\u4e0d\u662f\u81ea\u7136\u8bed\u8a00\u987a\u5e8f\u8fdb\u884c\u6392\u5e8f\u3002\u5bf9\u4e8e <code class=\"function\">lower</code>\u3001<code class=\"function\">initcap</code>\u548c <code class=\"function\">upper</code>\u51fd\u6570\uff0c\u5b83\u4f7f\u7528 Unicode \u5b8c\u6574\u5927\u5c0f\u5199\u6620\u5c04\u3002\u5bf9\u4e8e\u6a21\u5f0f\u5339\u914d\uff08\u5305\u62ec\u6b63\u5219\u8868\u8fbe\u5f0f\uff09\uff0c\u5b83\u4f7f\u7528 Unicode <a class=\"ulink\" href=\"https://www.unicode.org/reports/tr18/#Compatibility_Properties\" target=\"_top\">\u517c\u5bb9\u5c5e\u6027</a>\u7684\u6807\u51c6\u53d8\u4f53\u3002\u5176\u884c\u4e3a\u5728 <span class=\"productname\">Postgres</span>\u4e3b\u7248\u672c\u5185\u9ad8\u6548\u4e14\u7a33\u5b9a\u3002\u4ec5\u9002\u7528\u4e8e <code class=\"literal\">UTF8</code>\u7f16\u7801\u3002</p>\n</p>\n</dd>\n<dt><span class=\"term\"><code class=\"literal\">pg_c_utf8</code></span></dt>\n<dd>\n<p lang=\"zh\">\n<p>\u6b64\u6392\u5e8f\u89c4\u5219\u6309 Unicode \u4ee3\u7801\u70b9\u503c\u800c\u4e0d\u662f\u81ea\u7136\u8bed\u8a00\u987a\u5e8f\u8fdb\u884c\u6392\u5e8f\u3002\u5bf9\u4e8e <code class=\"function\">lower</code>\u3001<code class=\"function\">initcap</code>\u548c <code class=\"function\">upper</code>\u51fd\u6570\uff0c\u5b83\u4f7f\u7528 Unicode \u7b80\u5355\u5927\u5c0f\u5199\u6620\u5c04\u3002\u5bf9\u4e8e\u6a21\u5f0f\u5339\u914d\uff08\u5305\u62ec\u6b63\u5219\u8868\u8fbe\u5f0f\uff09\uff0c\u5b83\u4f7f\u7528 Unicode <a class=\"ulink\" href=\"https://www.unicode.org/reports/tr18/#Compatibility_Properties\" target=\"_top\">\u517c\u5bb9\u5c5e\u6027</a>\u7684 POSIX \u517c\u5bb9\u53d8\u4f53\u3002\u5176\u884c\u4e3a\u5728 <span class=\"productname\">PostgreSQL</span>\u4e3b\u7248\u672c\u5185\u9ad8\u6548\u4e14\u7a33\u5b9a\u3002\u6b64\u6392\u5e8f\u89c4\u5219\u4ec5\u9002\u7528\u4e8e<code class=\"literal\">UTF8</code>\u7f16\u7801\u3002</p>\n</p>\n</dd>\n<dt lang=\"zh\"><span class=\"term\"><code class=\"literal\">C</code>\uff08\u7b49\u540c\u4e8e<code class=\"literal\">POSIX</code>\uff09</span></dt>\n<dd>\n<p lang=\"zh\">\n<p><code class=\"literal\">C</code>\u548c<code class=\"literal\">POSIX</code>\u6392\u5e8f\u89c4\u5219\u57fa\u4e8e<span class=\"quote\">\u201c<span class=\"quote\">\u4f20\u7edf C</span>\u201d</span>\u884c\u4e3a\u3002\u5b83\u4eec\u6309\u5b57\u8282\u503c\u800c\u4e0d\u662f\u81ea\u7136\u8bed\u8a00\u987a\u5e8f\u6392\u5e8f\uff0c\u5e76\u4e14\u53ea\u6709 ASCII \u5b57\u6bcd<span class=\"quote\">\u201c<span class=\"quote\"><code class=\"literal\">A</code></span>\u201d</span>\u5230<span class=\"quote\">\u201c<span class=\"quote\"><code class=\"literal\">Z</code></span>\u201d</span>\u4f1a\u88ab\u89c6\u4e3a\u5b57\u6bcd\u3002\u5bf9\u4e8e\u7ed9\u5b9a\u7684\u6570\u636e\u5e93\u7f16\u7801\uff0c\u5176\u884c\u4e3a\u9ad8\u6548\u4e14\u5728\u6240\u6709\u7248\u672c\u4e2d\u90fd\u7a33\u5b9a\uff0c\u4f46\u5728\u4e0d\u540c\u6570\u636e\u5e93\u7f16\u7801\u4e4b\u95f4\u53ef\u80fd\u4f1a\u6709\u6240\u4e0d\u540c\u3002</p>\n</p>\n</dd>\n<dt lang=\"zh\">\u9ed8\u8ba4</dt>\n<dd>\n<p lang=\"zh\">\n<p><code class=\"literal\">default</code>\u6392\u5e8f\u89c4\u5219\u4f1a\u9009\u62e9\u6570\u636e\u5e93\u521b\u5efa\u65f6\u6307\u5b9a\u7684\u533a\u57df\u8bbe\u7f6e\u3002</p>\n</p>\n</dd>\n</dl>\n</div>\n<p lang=\"zh\">\u6839\u636e\u64cd\u4f5c\u7cfb\u7edf\u652f\u6301\u60c5\u51b5\uff0c\u8fd8\u53ef\u80fd\u5b58\u5728\u5176\u4ed6\u6392\u5e8f\u89c4\u5219\u3002\u8fd9\u4e9b\u9644\u52a0\u6392\u5e8f\u89c4\u5219\u7684\u6548\u7387\u548c\u7a33\u5b9a\u6027\u53d6\u51b3\u4e8e\u6392\u5e8f\u89c4\u5219\u63d0\u4f9b\u7a0b\u5e8f\u3001\u63d0\u4f9b\u7a0b\u5e8f\u7248\u672c\u4ee5\u53ca\u533a\u57df\u8bbe\u7f6e\u3002</p>\n</div>", "manual_path": "/docs/18/collation.html#COLLATION-MANAGING-STANDARD", "localization": {"status": "complete", "sources": [{"url": "/docs/18/collation.html", "method": "same-major semantic node", "sha256": "4fa99946c7c01ec3872b49a1fa92cadcd30d5a34d425829f836674d5c63b571a", "language": "zh", "matched_nodes": ["#COLLATION/div[4]/p[2]/span[0]/span[0]", "#COLLATION/div[5]/div[4]/div[0]", "#COLLATION/div[5]/div[4]/div[2]/dl[0]/dd[11]", "#COLLATION/div[5]/div[4]/div[2]/dl[0]/dd[1]", "#COLLATION/div[5]/div[4]/div[2]/dl[0]/dd[5]", "#COLLATION/div[5]/div[4]/div[2]/dl[0]/dd[7]", "#COLLATION/div[5]/div[4]/div[2]/dl[0]/dd[9]", "#COLLATION/div[5]/div[4]/div[2]/dl[0]/dt[8]", "#COLLATION/div[5]/div[4]/p[1]", "#COLLATION/div[5]/div[4]/p[3]"]}], "language": "zh", "original_text": {"/versions/18/description/0": "sorts by Unicode code point; Unicode character semantics", "/versions/18/facts/0/label": "Collisdeterministic", "/versions/18/facts/1/label": "Collcollate", "/versions/18/facts/2/label": "Collctype", "/versions/18/facts/3/label": "Colllocale", "/versions/18/facts/4/label": "Collicurules", "/versions/18/facts/5/label": "Collversion", "/versions/18/facts/6/label": "Collname", "/versions/18/facts/7/label": "Collprovider", "/versions/18/facts/8/label": "Collencoding", "/versions/18/related/0/label": "builtin provider"}, "fallback_fields": [], "source_language": "en", "original_snapshot_sha256": "76675ecf7af07367401bfacaa388ce95903c15e7a7487aa5cfa84913e4f8b2ff"}, "comparison_data": {"locale": "PG_UNICODE_FAST", "collname": "pg_unicode_fast", "collversion": "1", "collencoding": "6", "collprovider": "b", "collisdeterministic": "t"}, "comparison_hash": "6c14506a33a6e7605cd89dfe89b6382cf89a0d5a329b6dff5127220778617736", "manual_language": "zh"}, "comparison": {"left": "17", "right": "18", "status": "added", "diff": "--- PostgreSQL 17\n+++ PostgreSQL 18\n@@ -1 +1,8 @@\n-\u8be5\u7248\u672a\u6536\u5f55\n+{\n+  \"collencoding\": \"6\",\n+  \"collisdeterministic\": \"t\",\n+  \"collname\": \"pg_unicode_fast\",\n+  \"collprovider\": \"b\",\n+  \"collversion\": \"1\",\n+  \"locale\": \"PG_UNICODE_FAST\"\n+}"}}