{"kind": "locale", "major": "18", "item": {"slug": "provider-builtin", "name": "builtin", "name_zh": "", "category": "\u6392\u5e8f\u89c4\u5219\u63d0\u4f9b\u8005\u6807\u8bc6", "summary": "\u6392\u5e8f\u89c4\u5219\u4e0e\u7f16\u7801 provider-builtin\u3002", "aliases": [], "content_hash": "8d9b18e17a45151b00aa7ba320f010fd4b022b98706aa2bef392b53aa437f087", "versions": {"17": {"facts": [{"label": "\u63d0\u4f9b\u8005", "value": "builtin"}, {"label": "\u76ee\u5f55\u4ee3\u7801", "value": "b"}, {"label": "\u8303\u56f4", "value": "\u6e90\u7801\u4e2d\u7684\u63d0\u4f9b\u8005\u6807\u8bc6\uff1b\u5b89\u88c5\u6216\u6784\u5efa\u4e2d\u662f\u5426\u53ef\u7528\u53e6\u884c\u5224\u65ad"}], "tables": [], "aliases": [], "related": [], "release": {"ref": "https://ftp.postgresql.org/pub/source/v17.11/postgresql-17.11.tar.bz2", "label": "17.11", "major": "17", "channel": "stable", "revision": "dd27f2b3c59e73ed14aa3324901242bf69a032a6347805f274e6260322d42979", "source_sha256": "dd27f2b3c59e73ed14aa3324901242bf69a032a6347805f274e6260322d42979", "catalog_fingerprint": "4bbe3ac77becd618478f66aec420a533e9017be356c5c1d51a4b17f0fd497c07"}, "sources": [{"url": "https://ftp.postgresql.org/pub/source/v17.11/postgresql-17.11.tar.bz2", "label": "Matching PostgreSQL source archive", "sha256": "dd27f2b3c59e73ed14aa3324901242bf69a032a6347805f274e6260322d42979"}, {"url": "/docs/17/collation.html#COLLATION-CONCEPTS", "path": "collation.html", "label": "PostgreSQL 17 English manual", "sha256": "67aac7b4c281b861af98f8f644ba2c3381358ffed48a74134fc269d0ae968029"}], "zh_from": {"kind": "same-version-chinese-manual-with-source-derived-structured-summary", "manual": {"url": "/zh/docs/17/collation.html#COLLATION-CONCEPTS", "anchor": "COLLATION-CONCEPTS", "locale": "zh-Hans", "version": "17", "build_id": 105, "page_key": "collation.html", "extraction": "concept-introduction", "source_hash": "f1467c30d2ab8f7b29cf347a9abc46353d93bcc2762c21cc3fe173b428e8ed30", "fragment_sha256": "411685fd444f02479c9140652a767773144c34c797e57e966ff058b768401de9", "source_revision": "unknown:rendered-translation-baseline", "translation_revision": "git:b1b500221dbe5437cfca004d6b04d3f6e422765d;html-sha256:7340767258d21c21b36f373f1fff6bab2be18e0daca13a865129db6105c09efd", "translated_from_revision": null}, "body_sha256": "ee1edecd63e3fda8cfdadb9a765b15e234e22950b4f9036731f60825199a114d", "runtime_rerun": false, "authored_translation": "source-derived-structured-summary", "source_facts_revision": "dd27f2b3c59e73ed14aa3324901242bf69a032a6347805f274e6260322d42979"}, "facts_zh": [{"label": "\u63d0\u4f9b\u8005", "value": "builtin"}, {"label": "\u76ee\u5f55\u4ee3\u7801", "value": "b"}, {"label": "\u8303\u56f4", "value": "\u6e90\u7801\u4e2d\u7684\u63d0\u4f9b\u8005\u6807\u8bc6\uff1b\u5b89\u88c5\u6216\u6784\u5efa\u4e2d\u662f\u5426\u53ef\u7528\u53e6\u884c\u5224\u65ad"}], "sections": [], "center_zh": {"title": "builtin", "locale": "zh-Hans", "source": {"key": "provider-builtin", "locale": "zh-Hans", "version": "17", "text_hash": "f8bc1b3aa1155f8fbf15df788eacd593fcdc1dbab43122fa4843af6734ad9f81", "collection": "locale", "dataset_hash": "7c31b524dfe136022d39a6ae8dcfac6b3bbd5f8fdaf422536599981252aff0c9", "source_database": "center", "source_revision": "dd27f2b3c59e73ed14aa3324901242bf69a032a6347805f274e6260322d42979"}, "payload": {"facts": [{"label": "\u63d0\u4f9b\u8005", "value": "builtin"}, {"label": "\u76ee\u5f55\u4ee3\u7801", "value": "b"}, {"label": "\u8303\u56f4", "value": "\u6e90\u7801\u4e2d\u7684\u63d0\u4f9b\u8005\u6807\u8bc6\uff1b\u5b89\u88c5\u6216\u6784\u5efa\u4e2d\u662f\u5426\u53ef\u7528\u53e6\u884c\u5224\u65ad"}], "tables": [], "zh_from": {"kind": "same-version-chinese-manual-with-source-derived-structured-summary", "manual": {"url": "/zh/docs/17/collation.html#COLLATION-CONCEPTS", "anchor": "COLLATION-CONCEPTS", "locale": "zh-Hans", "version": "17", "build_id": 105, "page_key": "collation.html", "extraction": "concept-introduction", "source_hash": "f1467c30d2ab8f7b29cf347a9abc46353d93bcc2762c21cc3fe173b428e8ed30", "fragment_sha256": "411685fd444f02479c9140652a767773144c34c797e57e966ff058b768401de9", "source_revision": "unknown:rendered-translation-baseline", "translation_revision": "git:b1b500221dbe5437cfca004d6b04d3f6e422765d;html-sha256:7340767258d21c21b36f373f1fff6bab2be18e0daca13a865129db6105c09efd", "translated_from_revision": null}, "body_sha256": "ee1edecd63e3fda8cfdadb9a765b15e234e22950b4f9036731f60825199a114d", "runtime_rerun": false, "authored_translation": "source-derived-structured-summary", "source_facts_revision": "dd27f2b3c59e73ed14aa3324901242bf69a032a6347805f274e6260322d42979"}, "sections": [], "description_zh": "\u6392\u5e8f\u89c4\u5219\u4e0e\u7f16\u7801 provider-builtin\u3002", "description_zh_html": "<p>\u6392\u5e8f\u89c4\u5219\u4e0e\u7f16\u7801 provider-builtin\u3002</p><dl><dt>\u9002\u7528\u8303\u56f4</dt><dd><code>Source provider identity; installation/build availability is separate</code></dd></dl><h3>\u540c\u7248\u672c\u4e2d\u6587\u624b\u518c\u8282\u9009</h3><p>\n    \u4ece\u6982\u5ff5\u4e0a\u8bb2\uff0c\u6bcf\u4e2a\u652f\u6301\u6392\u5e8f\u89c4\u5219\u7684\u6570\u636e\u7c7b\u578b\u7684\u8868\u8fbe\u5f0f\u90fd\u6709\u4e00\u4e2a\u6392\u5e8f\u89c4\u5219\u3002\uff08\u5185\u7f6e\u7684\u652f\u6301\u6392\u5e8f\u89c4\u5219\u7684\u6570\u636e\u7c7b\u578b\u5305\u62ec <code class=\"type\">text</code>\u3001<code class=\"type\">varchar</code> \u548c <code class=\"type\">char</code>\u3002\u7528\u6237\u5b9a\u4e49\u7684\u57fa\u7840\u7c7b\u578b\u4e5f\u53ef\u4ee5\u6807\u8bb0\u4e3a\u652f\u6301\u6392\u5e8f\u89c4\u5219\uff0c\u5f53\u7136\uff0c\u5efa\u7acb\u5728\u652f\u6301\u6392\u5e8f\u89c4\u5219\u7684\u6570\u636e\u7c7b\u578b\u4e4b\u4e0a\u7684<a class=\"glossterm\" href=\"/zh/docs/17/glossary.html#GLOSSARY-DOMAIN\"><em class=\"glossterm\"></em></a><em class=\"glossterm\"><a class=\"glossterm\" href=\"/zh/docs/17/glossary.html#GLOSSARY-DOMAIN\">\u57df</a></em>\u4e5f\u652f\u6301\u6392\u5e8f\u89c4\u5219\u3002\uff09\u5982\u679c\u8868\u8fbe\u5f0f\u662f\u5217\u5f15\u7528\uff0c\u5219\u8be5\u8868\u8fbe\u5f0f\u7684\u6392\u5e8f\u89c4\u5219\u5c31\u662f\u8be5\u5217\u5b9a\u4e49\u7684\u6392\u5e8f\u89c4\u5219\u3002\u5982\u679c\u8868\u8fbe\u5f0f\u662f\u5e38\u91cf\uff0c\u5219\u5176\u6392\u5e8f\u89c4\u5219\u5c31\u662f\u8be5\u5e38\u91cf\u6570\u636e\u7c7b\u578b\u7684\u9ed8\u8ba4\u6392\u5e8f\u89c4\u5219\u3002\u66f4\u590d\u6742\u8868\u8fbe\u5f0f\u7684\u6392\u5e8f\u89c4\u5219\u5219\u6309\u4e0b\u6587\u6240\u8ff0\uff0c\u4ece\u5176\u8f93\u5165\u8868\u8fbe\u5f0f\u7684\u6392\u5e8f\u89c4\u5219\u63a8\u5bfc\u51fa\u6765\u3002\n   </p><p>\n    \u8868\u8fbe\u5f0f\u7684\u6392\u5e8f\u89c4\u5219\u53ef\u4ee5\u662f<span class=\"quote\">\u201c<span class=\"quote\">\u9ed8\u8ba4</span>\u201d</span>\u6392\u5e8f\u89c4\u5219\uff0c\u8fd9\u8868\u793a\u4e3a\u6570\u636e\u5e93\u5b9a\u4e49\u7684\u533a\u57df\u8bbe\u7f6e\u3002\u8868\u8fbe\u5f0f\u7684\u6392\u5e8f\u89c4\u5219\u4e5f\u53ef\u80fd\u662f\u4e0d\u786e\u5b9a\u7684\u3002\u5728\u8fd9\u79cd\u60c5\u51b5\u4e0b\uff0c\u6392\u5e8f\u64cd\u4f5c\u4ee5\u53ca\u5176\u4ed6\u9700\u8981\u77e5\u9053\u6392\u5e8f\u89c4\u5219\u7684\u64cd\u4f5c\u90fd\u4f1a\u5931\u8d25\u3002\n   </p><p>\n    \u5f53\u6570\u636e\u5e93\u7cfb\u7edf\u5fc5\u987b\u6267\u884c\u6392\u5e8f\u6216\u5b57\u7b26\u5206\u7c7b\u65f6\uff0c\u5b83\u4f1a\u4f7f\u7528\u8f93\u5165\u8868\u8fbe\u5f0f\u7684\u6392\u5e8f\u89c4\u5219\u3002\u4f8b\u5982\uff0c\u8fd9\u4f1a\u53d1\u751f\u5728 <code class=\"literal\">ORDER BY</code> \u5b50\u53e5\u4ee5\u53ca\u51fd\u6570\u6216\u64cd\u4f5c\u7b26\u8c03\u7528\uff08\u5982\n    <code class=\"literal\">&lt;</code>\uff09\u4e2d\u3002\u5e94\u7528\u4e8e <code class=\"literal\">ORDER BY</code> \u5b50\u53e5\u7684\u6392\u5e8f\u89c4\u5219\u5c31\u662f\u6392\u5e8f\u952e\u7684\u6392\u5e8f\u89c4\u5219\u3002\u5e94\u7528\u4e8e\u51fd\u6570\u6216\u64cd\u4f5c\u7b26\u8c03\u7528\u7684\u6392\u5e8f\u89c4\u5219\u5219\u6309\u4e0b\u6587\u6240\u8ff0\uff0c\u4ece\u53c2\u6570\u4e2d\u63a8\u5bfc\u51fa\u6765\u3002\u9664\u4e86\u6bd4\u8f83\u64cd\u4f5c\u7b26\u4e4b\u5916\uff0c\u5728\u5927\u5c0f\u5199\u4e4b\u95f4\u8fdb\u884c\u8f6c\u6362\u7684\u51fd\u6570\uff08\u4f8b\u5982 <code class=\"function\">lower</code>\u3001<code class=\"function\">upper</code> \u548c\n    <code class=\"function\">initcap</code>\uff09\u3001\u6a21\u5f0f\u5339\u914d\u64cd\u4f5c\u7b26\uff0c\u4ee5\u53ca <code class=\"function\">to_char</code>\n    \u53ca\u76f8\u5173\u51fd\u6570\uff0c\u4e5f\u90fd\u4f1a\u8003\u8651\u6392\u5e8f\u89c4\u5219\u3002\n   </p><p>\n    \u5bf9\u4e8e\u51fd\u6570\u6216\u64cd\u4f5c\u7b26\u8c03\u7528\uff0c\u901a\u8fc7\u68c0\u67e5\u53c2\u6570\u6392\u5e8f\u89c4\u5219\u63a8\u5bfc\u51fa\u7684\u6392\u5e8f\u89c4\u5219\uff0c\u4f1a\u5728\u8fd0\u884c\u65f6\u7528\u4e8e\u6267\u884c\u6307\u5b9a\u64cd\u4f5c\u3002\u5982\u679c\u8be5\u51fd\u6570\u6216\u64cd\u4f5c\u7b26\u8c03\u7528\u7684\u7ed3\u679c\u5c5e\u4e8e\u652f\u6301\u6392\u5e8f\u89c4\u5219\u7684\u6570\u636e\u7c7b\u578b\uff0c\u90a3\u4e48\u5728\u89e3\u6790\u65f6\u5b83\u4e5f\u4f1a\u88ab\u7528\u4f5c\u8be5\u51fd\u6570\u6216\u64cd\u4f5c\u7b26\u8868\u8fbe\u5f0f\u7684\u5df2\u5b9a\u4e49\u6392\u5e8f\u89c4\u5219\uff0c\u4ee5\u4fbf\u5728\u5916\u56f4\u8868\u8fbe\u5f0f\u9700\u8981\u77e5\u9053\u5176\u6392\u5e8f\u89c4\u5219\u65f6\u4f7f\u7528\u3002\n   </p><p><a href=\"/zh/docs/17/collation.html#COLLATION-CONCEPTS\">\u67e5\u770b\u5b8c\u6574\u4e2d\u6587\u624b\u518c\u4e0e\u4e0a\u4e0b\u6587</a>\u3002</p>"}, "summary": "\u6392\u5e8f\u89c4\u5219\u4e0e\u7f16\u7801 provider-builtin\u3002", "version": "17", "link_map": {"/zh/docs/17/glossary.html#GLOSSARY-DOMAIN": "/docs/17/glossary.html#GLOSSARY-DOMAIN", "/zh/docs/17/collation.html#COLLATION-CONCEPTS": "/docs/17/collation.html#COLLATION-CONCEPTS"}, "body_html": "<p>\u6392\u5e8f\u89c4\u5219\u4e0e\u7f16\u7801 provider-builtin\u3002</p><dl><dt>\u9002\u7528\u8303\u56f4</dt><dd><code>Source provider identity; installation/build availability is separate</code></dd></dl><h3>\u540c\u7248\u672c\u4e2d\u6587\u624b\u518c\u8282\u9009</h3><p>\n    \u4ece\u6982\u5ff5\u4e0a\u8bb2\uff0c\u6bcf\u4e2a\u652f\u6301\u6392\u5e8f\u89c4\u5219\u7684\u6570\u636e\u7c7b\u578b\u7684\u8868\u8fbe\u5f0f\u90fd\u6709\u4e00\u4e2a\u6392\u5e8f\u89c4\u5219\u3002\uff08\u5185\u7f6e\u7684\u652f\u6301\u6392\u5e8f\u89c4\u5219\u7684\u6570\u636e\u7c7b\u578b\u5305\u62ec <code>text</code>\u3001<code>varchar</code> \u548c <code>char</code>\u3002\u7528\u6237\u5b9a\u4e49\u7684\u57fa\u7840\u7c7b\u578b\u4e5f\u53ef\u4ee5\u6807\u8bb0\u4e3a\u652f\u6301\u6392\u5e8f\u89c4\u5219\uff0c\u5f53\u7136\uff0c\u5efa\u7acb\u5728\u652f\u6301\u6392\u5e8f\u89c4\u5219\u7684\u6570\u636e\u7c7b\u578b\u4e4b\u4e0a\u7684<a href=\"/zh/docs/17/glossary.html#GLOSSARY-DOMAIN\" rel=\"nofollow\"><em></em></a><em><a href=\"/zh/docs/17/glossary.html#GLOSSARY-DOMAIN\" rel=\"nofollow\">\u57df</a></em>\u4e5f\u652f\u6301\u6392\u5e8f\u89c4\u5219\u3002\uff09\u5982\u679c\u8868\u8fbe\u5f0f\u662f\u5217\u5f15\u7528\uff0c\u5219\u8be5\u8868\u8fbe\u5f0f\u7684\u6392\u5e8f\u89c4\u5219\u5c31\u662f\u8be5\u5217\u5b9a\u4e49\u7684\u6392\u5e8f\u89c4\u5219\u3002\u5982\u679c\u8868\u8fbe\u5f0f\u662f\u5e38\u91cf\uff0c\u5219\u5176\u6392\u5e8f\u89c4\u5219\u5c31\u662f\u8be5\u5e38\u91cf\u6570\u636e\u7c7b\u578b\u7684\u9ed8\u8ba4\u6392\u5e8f\u89c4\u5219\u3002\u66f4\u590d\u6742\u8868\u8fbe\u5f0f\u7684\u6392\u5e8f\u89c4\u5219\u5219\u6309\u4e0b\u6587\u6240\u8ff0\uff0c\u4ece\u5176\u8f93\u5165\u8868\u8fbe\u5f0f\u7684\u6392\u5e8f\u89c4\u5219\u63a8\u5bfc\u51fa\u6765\u3002\n   </p><p>\n    \u8868\u8fbe\u5f0f\u7684\u6392\u5e8f\u89c4\u5219\u53ef\u4ee5\u662f<span>\u201c<span>\u9ed8\u8ba4</span>\u201d</span>\u6392\u5e8f\u89c4\u5219\uff0c\u8fd9\u8868\u793a\u4e3a\u6570\u636e\u5e93\u5b9a\u4e49\u7684\u533a\u57df\u8bbe\u7f6e\u3002\u8868\u8fbe\u5f0f\u7684\u6392\u5e8f\u89c4\u5219\u4e5f\u53ef\u80fd\u662f\u4e0d\u786e\u5b9a\u7684\u3002\u5728\u8fd9\u79cd\u60c5\u51b5\u4e0b\uff0c\u6392\u5e8f\u64cd\u4f5c\u4ee5\u53ca\u5176\u4ed6\u9700\u8981\u77e5\u9053\u6392\u5e8f\u89c4\u5219\u7684\u64cd\u4f5c\u90fd\u4f1a\u5931\u8d25\u3002\n   </p><p>\n    \u5f53\u6570\u636e\u5e93\u7cfb\u7edf\u5fc5\u987b\u6267\u884c\u6392\u5e8f\u6216\u5b57\u7b26\u5206\u7c7b\u65f6\uff0c\u5b83\u4f1a\u4f7f\u7528\u8f93\u5165\u8868\u8fbe\u5f0f\u7684\u6392\u5e8f\u89c4\u5219\u3002\u4f8b\u5982\uff0c\u8fd9\u4f1a\u53d1\u751f\u5728 <code>ORDER BY</code> \u5b50\u53e5\u4ee5\u53ca\u51fd\u6570\u6216\u64cd\u4f5c\u7b26\u8c03\u7528\uff08\u5982\n    <code>&lt;</code>\uff09\u4e2d\u3002\u5e94\u7528\u4e8e <code>ORDER BY</code> \u5b50\u53e5\u7684\u6392\u5e8f\u89c4\u5219\u5c31\u662f\u6392\u5e8f\u952e\u7684\u6392\u5e8f\u89c4\u5219\u3002\u5e94\u7528\u4e8e\u51fd\u6570\u6216\u64cd\u4f5c\u7b26\u8c03\u7528\u7684\u6392\u5e8f\u89c4\u5219\u5219\u6309\u4e0b\u6587\u6240\u8ff0\uff0c\u4ece\u53c2\u6570\u4e2d\u63a8\u5bfc\u51fa\u6765\u3002\u9664\u4e86\u6bd4\u8f83\u64cd\u4f5c\u7b26\u4e4b\u5916\uff0c\u5728\u5927\u5c0f\u5199\u4e4b\u95f4\u8fdb\u884c\u8f6c\u6362\u7684\u51fd\u6570\uff08\u4f8b\u5982 <code>lower</code>\u3001<code>upper</code> \u548c\n    <code>initcap</code>\uff09\u3001\u6a21\u5f0f\u5339\u914d\u64cd\u4f5c\u7b26\uff0c\u4ee5\u53ca <code>to_char</code>\n    \u53ca\u76f8\u5173\u51fd\u6570\uff0c\u4e5f\u90fd\u4f1a\u8003\u8651\u6392\u5e8f\u89c4\u5219\u3002\n   </p><p>\n    \u5bf9\u4e8e\u51fd\u6570\u6216\u64cd\u4f5c\u7b26\u8c03\u7528\uff0c\u901a\u8fc7\u68c0\u67e5\u53c2\u6570\u6392\u5e8f\u89c4\u5219\u63a8\u5bfc\u51fa\u7684\u6392\u5e8f\u89c4\u5219\uff0c\u4f1a\u5728\u8fd0\u884c\u65f6\u7528\u4e8e\u6267\u884c\u6307\u5b9a\u64cd\u4f5c\u3002\u5982\u679c\u8be5\u51fd\u6570\u6216\u64cd\u4f5c\u7b26\u8c03\u7528\u7684\u7ed3\u679c\u5c5e\u4e8e\u652f\u6301\u6392\u5e8f\u89c4\u5219\u7684\u6570\u636e\u7c7b\u578b\uff0c\u90a3\u4e48\u5728\u89e3\u6790\u65f6\u5b83\u4e5f\u4f1a\u88ab\u7528\u4f5c\u8be5\u51fd\u6570\u6216\u64cd\u4f5c\u7b26\u8868\u8fbe\u5f0f\u7684\u5df2\u5b9a\u4e49\u6392\u5e8f\u89c4\u5219\uff0c\u4ee5\u4fbf\u5728\u5916\u56f4\u8868\u8fbe\u5f0f\u9700\u8981\u77e5\u9053\u5176\u6392\u5e8f\u89c4\u5219\u65f6\u4f7f\u7528\u3002\n   </p><p><a href=\"/zh/docs/17/collation.html#COLLATION-CONCEPTS\" rel=\"nofollow\">\u67e5\u770b\u5b8c\u6574\u4e2d\u6587\u624b\u518c\u4e0e\u4e0a\u4e0b\u6587</a>\u3002</p>", "body_sha256": "1ce7d441aa1ae0806df0af0bb18f5c6d85d5967a1e4b76d1ffbf74c46ae05336", "content_hash": "f8bc1b3aa1155f8fbf15df788eacd593fcdc1dbab43122fa4843af6734ad9f81", "source_database": "center", "source_revision": "dd27f2b3c59e73ed14aa3324901242bf69a032a6347805f274e6260322d42979"}, "signature": "", "tables_zh": [], "attributes": {"scope": "Source provider identity; installation/build availability is separate", "provider": "builtin", "catalog_code": "b"}, "description": ["\u6392\u5e8f\u89c4\u5219\u4e0e\u7f16\u7801 provider-builtin\u3002"], "manual_html": "", "manual_path": "/docs/17/collation.html#COLLATION-CONCEPTS", "sections_zh": [], "localization": {"status": "complete", "sources": [{"url": "/docs/17/collation.html", "method": "same-major semantic node", "sha256": "627c5dcdd88e58465c57ce7a241857c03ac446c489409a618cdf3ed05459d7b5", "language": "zh", "matched_nodes": ["#COLLATION/div[1]/dl[0]/dt[0]", "#COLLATION/div[4]/div[6]/ol[0]/li[0]", "#COLLATION/div[4]/div[6]/ol[0]/li[1]", "#COLLATION/div[4]/div[6]/ol[0]/li[2]", "#COLLATION/div[4]/p[11]", "#COLLATION/div[4]/p[13]", "#COLLATION/div[4]/p[15]", "#COLLATION/div[4]/p[17]", "#COLLATION/div[4]/p[19]", "#COLLATION/div[4]/p[1]", "#COLLATION/div[4]/p[21]", "#COLLATION/div[4]/p[22]", "#COLLATION/div[4]/p[24]", "#COLLATION/div[4]/p[26]", "#COLLATION/div[4]/p[2]", "#COLLATION/div[4]/p[3]", "#COLLATION/div[4]/p[4]", "#COLLATION/div[4]/p[5]", "#COLLATION/div[4]/p[7]", "#COLLATION/div[4]/p[9]"]}], "language": "zh", "original_text": {"/versions/17/description/0": "builtin collation provider.", "/versions/17/facts/0/label": "Provider", "/versions/17/facts/1/label": "Catalog code", "/versions/17/facts/2/label": "Scope", "/versions/17/facts/2/value": "Source provider identity; installation/build availability is separate"}, "fallback_fields": [], "source_language": "en", "original_snapshot_sha256": "0ae35455662804d57e5c81c43e49efd0679506ec683e7baae6f04389b709ccb7", "canonical_center_text_hash": "f8bc1b3aa1155f8fbf15df788eacd593fcdc1dbab43122fa4843af6734ad9f81"}, "description_zh": "\u6392\u5e8f\u89c4\u5219\u4e0e\u7f16\u7801 provider-builtin\u3002", "comparison_data": {"scope": "Source provider identity; installation/build availability is separate", "provider": "builtin", "catalog_code": "b"}, "comparison_hash": "d0ee87b3545cc68aafaa491d16e6d3a73ddc2ded39dd20ba234b922cd06fd397", "manual_language": "zh", "description_zh_html": "<p>\u6392\u5e8f\u89c4\u5219\u4e0e\u7f16\u7801 provider-builtin\u3002</p><dl><dt>\u9002\u7528\u8303\u56f4</dt><dd><code>Source provider identity; installation/build availability is separate</code></dd></dl><h3>\u540c\u7248\u672c\u4e2d\u6587\u624b\u518c\u8282\u9009</h3><p>\n    \u4ece\u6982\u5ff5\u4e0a\u8bb2\uff0c\u6bcf\u4e2a\u652f\u6301\u6392\u5e8f\u89c4\u5219\u7684\u6570\u636e\u7c7b\u578b\u7684\u8868\u8fbe\u5f0f\u90fd\u6709\u4e00\u4e2a\u6392\u5e8f\u89c4\u5219\u3002\uff08\u5185\u7f6e\u7684\u652f\u6301\u6392\u5e8f\u89c4\u5219\u7684\u6570\u636e\u7c7b\u578b\u5305\u62ec <code>text</code>\u3001<code>varchar</code> \u548c <code>char</code>\u3002\u7528\u6237\u5b9a\u4e49\u7684\u57fa\u7840\u7c7b\u578b\u4e5f\u53ef\u4ee5\u6807\u8bb0\u4e3a\u652f\u6301\u6392\u5e8f\u89c4\u5219\uff0c\u5f53\u7136\uff0c\u5efa\u7acb\u5728\u652f\u6301\u6392\u5e8f\u89c4\u5219\u7684\u6570\u636e\u7c7b\u578b\u4e4b\u4e0a\u7684<a href=\"/zh/docs/17/glossary.html#GLOSSARY-DOMAIN\" rel=\"nofollow\"><em></em></a><em><a href=\"/zh/docs/17/glossary.html#GLOSSARY-DOMAIN\" rel=\"nofollow\">\u57df</a></em>\u4e5f\u652f\u6301\u6392\u5e8f\u89c4\u5219\u3002\uff09\u5982\u679c\u8868\u8fbe\u5f0f\u662f\u5217\u5f15\u7528\uff0c\u5219\u8be5\u8868\u8fbe\u5f0f\u7684\u6392\u5e8f\u89c4\u5219\u5c31\u662f\u8be5\u5217\u5b9a\u4e49\u7684\u6392\u5e8f\u89c4\u5219\u3002\u5982\u679c\u8868\u8fbe\u5f0f\u662f\u5e38\u91cf\uff0c\u5219\u5176\u6392\u5e8f\u89c4\u5219\u5c31\u662f\u8be5\u5e38\u91cf\u6570\u636e\u7c7b\u578b\u7684\u9ed8\u8ba4\u6392\u5e8f\u89c4\u5219\u3002\u66f4\u590d\u6742\u8868\u8fbe\u5f0f\u7684\u6392\u5e8f\u89c4\u5219\u5219\u6309\u4e0b\u6587\u6240\u8ff0\uff0c\u4ece\u5176\u8f93\u5165\u8868\u8fbe\u5f0f\u7684\u6392\u5e8f\u89c4\u5219\u63a8\u5bfc\u51fa\u6765\u3002\n   </p><p>\n    \u8868\u8fbe\u5f0f\u7684\u6392\u5e8f\u89c4\u5219\u53ef\u4ee5\u662f<span>\u201c<span>\u9ed8\u8ba4</span>\u201d</span>\u6392\u5e8f\u89c4\u5219\uff0c\u8fd9\u8868\u793a\u4e3a\u6570\u636e\u5e93\u5b9a\u4e49\u7684\u533a\u57df\u8bbe\u7f6e\u3002\u8868\u8fbe\u5f0f\u7684\u6392\u5e8f\u89c4\u5219\u4e5f\u53ef\u80fd\u662f\u4e0d\u786e\u5b9a\u7684\u3002\u5728\u8fd9\u79cd\u60c5\u51b5\u4e0b\uff0c\u6392\u5e8f\u64cd\u4f5c\u4ee5\u53ca\u5176\u4ed6\u9700\u8981\u77e5\u9053\u6392\u5e8f\u89c4\u5219\u7684\u64cd\u4f5c\u90fd\u4f1a\u5931\u8d25\u3002\n   </p><p>\n    \u5f53\u6570\u636e\u5e93\u7cfb\u7edf\u5fc5\u987b\u6267\u884c\u6392\u5e8f\u6216\u5b57\u7b26\u5206\u7c7b\u65f6\uff0c\u5b83\u4f1a\u4f7f\u7528\u8f93\u5165\u8868\u8fbe\u5f0f\u7684\u6392\u5e8f\u89c4\u5219\u3002\u4f8b\u5982\uff0c\u8fd9\u4f1a\u53d1\u751f\u5728 <code>ORDER BY</code> \u5b50\u53e5\u4ee5\u53ca\u51fd\u6570\u6216\u64cd\u4f5c\u7b26\u8c03\u7528\uff08\u5982\n    <code>&lt;</code>\uff09\u4e2d\u3002\u5e94\u7528\u4e8e <code>ORDER BY</code> \u5b50\u53e5\u7684\u6392\u5e8f\u89c4\u5219\u5c31\u662f\u6392\u5e8f\u952e\u7684\u6392\u5e8f\u89c4\u5219\u3002\u5e94\u7528\u4e8e\u51fd\u6570\u6216\u64cd\u4f5c\u7b26\u8c03\u7528\u7684\u6392\u5e8f\u89c4\u5219\u5219\u6309\u4e0b\u6587\u6240\u8ff0\uff0c\u4ece\u53c2\u6570\u4e2d\u63a8\u5bfc\u51fa\u6765\u3002\u9664\u4e86\u6bd4\u8f83\u64cd\u4f5c\u7b26\u4e4b\u5916\uff0c\u5728\u5927\u5c0f\u5199\u4e4b\u95f4\u8fdb\u884c\u8f6c\u6362\u7684\u51fd\u6570\uff08\u4f8b\u5982 <code>lower</code>\u3001<code>upper</code> \u548c\n    <code>initcap</code>\uff09\u3001\u6a21\u5f0f\u5339\u914d\u64cd\u4f5c\u7b26\uff0c\u4ee5\u53ca <code>to_char</code>\n    \u53ca\u76f8\u5173\u51fd\u6570\uff0c\u4e5f\u90fd\u4f1a\u8003\u8651\u6392\u5e8f\u89c4\u5219\u3002\n   </p><p>\n    \u5bf9\u4e8e\u51fd\u6570\u6216\u64cd\u4f5c\u7b26\u8c03\u7528\uff0c\u901a\u8fc7\u68c0\u67e5\u53c2\u6570\u6392\u5e8f\u89c4\u5219\u63a8\u5bfc\u51fa\u7684\u6392\u5e8f\u89c4\u5219\uff0c\u4f1a\u5728\u8fd0\u884c\u65f6\u7528\u4e8e\u6267\u884c\u6307\u5b9a\u64cd\u4f5c\u3002\u5982\u679c\u8be5\u51fd\u6570\u6216\u64cd\u4f5c\u7b26\u8c03\u7528\u7684\u7ed3\u679c\u5c5e\u4e8e\u652f\u6301\u6392\u5e8f\u89c4\u5219\u7684\u6570\u636e\u7c7b\u578b\uff0c\u90a3\u4e48\u5728\u89e3\u6790\u65f6\u5b83\u4e5f\u4f1a\u88ab\u7528\u4f5c\u8be5\u51fd\u6570\u6216\u64cd\u4f5c\u7b26\u8868\u8fbe\u5f0f\u7684\u5df2\u5b9a\u4e49\u6392\u5e8f\u89c4\u5219\uff0c\u4ee5\u4fbf\u5728\u5916\u56f4\u8868\u8fbe\u5f0f\u9700\u8981\u77e5\u9053\u5176\u6392\u5e8f\u89c4\u5219\u65f6\u4f7f\u7528\u3002\n   </p><p><a href=\"/zh/docs/17/collation.html#COLLATION-CONCEPTS\" rel=\"nofollow\">\u67e5\u770b\u5b8c\u6574\u4e2d\u6587\u624b\u518c\u4e0e\u4e0a\u4e0b\u6587</a>\u3002</p>"}, "18": {"facts": [{"label": "\u63d0\u4f9b\u8005", "value": "builtin"}, {"label": "\u76ee\u5f55\u4ee3\u7801", "value": "b"}, {"label": "\u8303\u56f4", "value": "\u6e90\u7801\u4e2d\u7684\u63d0\u4f9b\u8005\u6807\u8bc6\uff1b\u5b89\u88c5\u6216\u6784\u5efa\u4e2d\u662f\u5426\u53ef\u7528\u53e6\u884c\u5224\u65ad"}], "tables": [], "aliases": [], "related": [], "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": "/docs/18/collation.html#COLLATION-CONCEPTS", "path": "collation.html", "label": "PostgreSQL 18 English manual", "sha256": "c98cbca2b2235a896f7fe438a88a99b8d6b9d1f50bdb49fe2794e9982a50797f"}], "zh_from": {"kind": "same-version-chinese-manual-with-source-derived-structured-summary", "manual": {"url": "/zh/docs/18/collation.html#COLLATION-CONCEPTS", "anchor": "COLLATION-CONCEPTS", "locale": "zh-Hans", "version": "18", "build_id": 107, "page_key": "collation.html", "extraction": "concept-introduction", "source_hash": "0bbcf85c650ba958c8d947a7a456ac42ada62afdf57cc030f62d93f756661fac", "fragment_sha256": "a57382d34f6fe21fe2e1d3927479580bbac33099cf1802452a272b78e65aab98", "source_revision": "unknown:rendered-translation-baseline", "translation_revision": "git:b1b500221dbe5437cfca004d6b04d3f6e422765d;html-sha256:08e987a66af27b98444a8057c256314eafa13611a3fb9e888214fc436824244b", "translated_from_revision": null}, "body_sha256": "5ab56ea97e93ce72443a3fa627d29c4a55cb55b0cf3f6d7a7643eda06f6280aa", "runtime_rerun": false, "authored_translation": "source-derived-structured-summary", "source_facts_revision": "555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f"}, "facts_zh": [{"label": "\u63d0\u4f9b\u8005", "value": "builtin"}, {"label": "\u76ee\u5f55\u4ee3\u7801", "value": "b"}, {"label": "\u8303\u56f4", "value": "\u6e90\u7801\u4e2d\u7684\u63d0\u4f9b\u8005\u6807\u8bc6\uff1b\u5b89\u88c5\u6216\u6784\u5efa\u4e2d\u662f\u5426\u53ef\u7528\u53e6\u884c\u5224\u65ad"}], "sections": [], "center_zh": {"title": "builtin", "locale": "zh-Hans", "source": {"key": "provider-builtin", "locale": "zh-Hans", "version": "18", "text_hash": "387483eca2a1d74c471b9c7c24de04e29af1e3459dc81a74718c821ca634b2a1", "collection": "locale", "dataset_hash": "7c31b524dfe136022d39a6ae8dcfac6b3bbd5f8fdaf422536599981252aff0c9", "source_database": "center", "source_revision": "555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f"}, "payload": {"facts": [{"label": "\u63d0\u4f9b\u8005", "value": "builtin"}, {"label": "\u76ee\u5f55\u4ee3\u7801", "value": "b"}, {"label": "\u8303\u56f4", "value": "\u6e90\u7801\u4e2d\u7684\u63d0\u4f9b\u8005\u6807\u8bc6\uff1b\u5b89\u88c5\u6216\u6784\u5efa\u4e2d\u662f\u5426\u53ef\u7528\u53e6\u884c\u5224\u65ad"}], "tables": [], "zh_from": {"kind": "same-version-chinese-manual-with-source-derived-structured-summary", "manual": {"url": "/zh/docs/18/collation.html#COLLATION-CONCEPTS", "anchor": "COLLATION-CONCEPTS", "locale": "zh-Hans", "version": "18", "build_id": 107, "page_key": "collation.html", "extraction": "concept-introduction", "source_hash": "0bbcf85c650ba958c8d947a7a456ac42ada62afdf57cc030f62d93f756661fac", "fragment_sha256": "a57382d34f6fe21fe2e1d3927479580bbac33099cf1802452a272b78e65aab98", "source_revision": "unknown:rendered-translation-baseline", "translation_revision": "git:b1b500221dbe5437cfca004d6b04d3f6e422765d;html-sha256:08e987a66af27b98444a8057c256314eafa13611a3fb9e888214fc436824244b", "translated_from_revision": null}, "body_sha256": "5ab56ea97e93ce72443a3fa627d29c4a55cb55b0cf3f6d7a7643eda06f6280aa", "runtime_rerun": false, "authored_translation": "source-derived-structured-summary", "source_facts_revision": "555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f"}, "sections": [], "description_zh": "\u6392\u5e8f\u89c4\u5219\u4e0e\u7f16\u7801 provider-builtin\u3002", "description_zh_html": "<p>\u6392\u5e8f\u89c4\u5219\u4e0e\u7f16\u7801 provider-builtin\u3002</p><dl><dt>\u9002\u7528\u8303\u56f4</dt><dd><code>Source provider identity; installation/build availability is separate</code></dd></dl><h3>\u540c\u7248\u672c\u4e2d\u6587\u624b\u518c\u8282\u9009</h3><p>\n    \u4ece\u6982\u5ff5\u4e0a\u8bb2\uff0c\u6bcf\u4e2a\u652f\u6301\u6392\u5e8f\u89c4\u5219\u7684\u6570\u636e\u7c7b\u578b\u7684\u8868\u8fbe\u5f0f\u90fd\u6709\u4e00\u4e2a\u6392\u5e8f\u89c4\u5219\u3002\uff08\u5185\u7f6e\u7684\u652f\u6301\u6392\u5e8f\u89c4\u5219\u7684\u6570\u636e\u7c7b\u578b\u5305\u62ec <code class=\"type\">text</code>\u3001<code class=\"type\">varchar</code> \u548c <code class=\"type\">char</code>\u3002\u7528\u6237\u5b9a\u4e49\u7684\u57fa\u7840\u7c7b\u578b\u4e5f\u53ef\u4ee5\u6807\u8bb0\u4e3a\u652f\u6301\u6392\u5e8f\u89c4\u5219\uff0c\u5f53\u7136\uff0c\u5efa\u7acb\u5728\u652f\u6301\u6392\u5e8f\u89c4\u5219\u7684\u6570\u636e\u7c7b\u578b\u4e4b\u4e0a\u7684<a class=\"glossterm\" href=\"/zh/docs/18/glossary.html#GLOSSARY-DOMAIN\"><em class=\"glossterm\"></em></a><em class=\"glossterm\"><a class=\"glossterm\" href=\"/zh/docs/18/glossary.html#GLOSSARY-DOMAIN\">\u57df</a></em>\u4e5f\u652f\u6301\u6392\u5e8f\u89c4\u5219\u3002\uff09\u5982\u679c\u8868\u8fbe\u5f0f\u662f\u5217\u5f15\u7528\uff0c\u5219\u8be5\u8868\u8fbe\u5f0f\u7684\u6392\u5e8f\u89c4\u5219\u5c31\u662f\u8be5\u5217\u5b9a\u4e49\u7684\u6392\u5e8f\u89c4\u5219\u3002\u5982\u679c\u8868\u8fbe\u5f0f\u662f\u5e38\u91cf\uff0c\u5219\u5176\u6392\u5e8f\u89c4\u5219\u5c31\u662f\u8be5\u5e38\u91cf\u6570\u636e\u7c7b\u578b\u7684\u9ed8\u8ba4\u6392\u5e8f\u89c4\u5219\u3002\u66f4\u590d\u6742\u8868\u8fbe\u5f0f\u7684\u6392\u5e8f\u89c4\u5219\u5219\u6309\u4e0b\u6587\u6240\u8ff0\uff0c\u4ece\u5176\u8f93\u5165\u8868\u8fbe\u5f0f\u7684\u6392\u5e8f\u89c4\u5219\u63a8\u5bfc\u51fa\u6765\u3002\n   </p><p>\n    \u8868\u8fbe\u5f0f\u7684\u6392\u5e8f\u89c4\u5219\u53ef\u4ee5\u662f<span class=\"quote\">\u201c<span class=\"quote\">\u9ed8\u8ba4</span>\u201d</span>\u6392\u5e8f\u89c4\u5219\uff0c\u8fd9\u8868\u793a\u4e3a\u6570\u636e\u5e93\u5b9a\u4e49\u7684\u533a\u57df\u8bbe\u7f6e\u3002\u8868\u8fbe\u5f0f\u7684\u6392\u5e8f\u89c4\u5219\u4e5f\u53ef\u80fd\u662f\u4e0d\u786e\u5b9a\u7684\u3002\u5728\u8fd9\u79cd\u60c5\u51b5\u4e0b\uff0c\u6392\u5e8f\u64cd\u4f5c\u4ee5\u53ca\u5176\u4ed6\u9700\u8981\u77e5\u9053\u6392\u5e8f\u89c4\u5219\u7684\u64cd\u4f5c\u90fd\u4f1a\u5931\u8d25\u3002\n   </p><p>\n    \u5f53\u6570\u636e\u5e93\u7cfb\u7edf\u5fc5\u987b\u6267\u884c\u6392\u5e8f\u6216\u5b57\u7b26\u5206\u7c7b\u65f6\uff0c\u5b83\u4f1a\u4f7f\u7528\u8f93\u5165\u8868\u8fbe\u5f0f\u7684\u6392\u5e8f\u89c4\u5219\u3002\u4f8b\u5982\uff0c\u8fd9\u4f1a\u53d1\u751f\u5728 <code class=\"literal\">ORDER BY</code> \u5b50\u53e5\u4ee5\u53ca\u51fd\u6570\u6216\u64cd\u4f5c\u7b26\u8c03\u7528\uff08\u5982\n    <code class=\"literal\">&lt;</code>\uff09\u4e2d\u3002\u5e94\u7528\u4e8e <code class=\"literal\">ORDER BY</code> \u5b50\u53e5\u7684\u6392\u5e8f\u89c4\u5219\u5c31\u662f\u6392\u5e8f\u952e\u7684\u6392\u5e8f\u89c4\u5219\u3002\u5e94\u7528\u4e8e\u51fd\u6570\u6216\u64cd\u4f5c\u7b26\u8c03\u7528\u7684\u6392\u5e8f\u89c4\u5219\u5219\u6309\u4e0b\u6587\u6240\u8ff0\uff0c\u4ece\u53c2\u6570\u4e2d\u63a8\u5bfc\u51fa\u6765\u3002\u9664\u4e86\u6bd4\u8f83\u64cd\u4f5c\u7b26\u4e4b\u5916\uff0c\u5728\u5927\u5c0f\u5199\u4e4b\u95f4\u8fdb\u884c\u8f6c\u6362\u7684\u51fd\u6570\uff08\u4f8b\u5982 <code class=\"function\">lower</code>\u3001<code class=\"function\">upper</code> \u548c\n    <code class=\"function\">initcap</code>\uff09\u3001\u6a21\u5f0f\u5339\u914d\u64cd\u4f5c\u7b26\uff0c\u4ee5\u53ca <code class=\"function\">to_char</code>\n    \u53ca\u76f8\u5173\u51fd\u6570\uff0c\u4e5f\u90fd\u4f1a\u8003\u8651\u6392\u5e8f\u89c4\u5219\u3002\n   </p><p>\n    \u5bf9\u4e8e\u51fd\u6570\u6216\u64cd\u4f5c\u7b26\u8c03\u7528\uff0c\u901a\u8fc7\u68c0\u67e5\u53c2\u6570\u6392\u5e8f\u89c4\u5219\u63a8\u5bfc\u51fa\u7684\u6392\u5e8f\u89c4\u5219\uff0c\u4f1a\u5728\u8fd0\u884c\u65f6\u7528\u4e8e\u6267\u884c\u6307\u5b9a\u64cd\u4f5c\u3002\u5982\u679c\u8be5\u51fd\u6570\u6216\u64cd\u4f5c\u7b26\u8c03\u7528\u7684\u7ed3\u679c\u5c5e\u4e8e\u652f\u6301\u6392\u5e8f\u89c4\u5219\u7684\u6570\u636e\u7c7b\u578b\uff0c\u90a3\u4e48\u5728\u89e3\u6790\u65f6\u5b83\u4e5f\u4f1a\u88ab\u7528\u4f5c\u8be5\u51fd\u6570\u6216\u64cd\u4f5c\u7b26\u8868\u8fbe\u5f0f\u7684\u5df2\u5b9a\u4e49\u6392\u5e8f\u89c4\u5219\uff0c\u4ee5\u4fbf\u5728\u5916\u56f4\u8868\u8fbe\u5f0f\u9700\u8981\u77e5\u9053\u5176\u6392\u5e8f\u89c4\u5219\u65f6\u4f7f\u7528\u3002\n   </p><p><a href=\"/zh/docs/18/collation.html#COLLATION-CONCEPTS\">\u67e5\u770b\u5b8c\u6574\u4e2d\u6587\u624b\u518c\u4e0e\u4e0a\u4e0b\u6587</a>\u3002</p>"}, "summary": "\u6392\u5e8f\u89c4\u5219\u4e0e\u7f16\u7801 provider-builtin\u3002", "version": "18", "link_map": {"/zh/docs/18/glossary.html#GLOSSARY-DOMAIN": "/docs/18/glossary.html#GLOSSARY-DOMAIN", "/zh/docs/18/collation.html#COLLATION-CONCEPTS": "/docs/18/collation.html#COLLATION-CONCEPTS"}, "body_html": "<p>\u6392\u5e8f\u89c4\u5219\u4e0e\u7f16\u7801 provider-builtin\u3002</p><dl><dt>\u9002\u7528\u8303\u56f4</dt><dd><code>Source provider identity; installation/build availability is separate</code></dd></dl><h3>\u540c\u7248\u672c\u4e2d\u6587\u624b\u518c\u8282\u9009</h3><p>\n    \u4ece\u6982\u5ff5\u4e0a\u8bb2\uff0c\u6bcf\u4e2a\u652f\u6301\u6392\u5e8f\u89c4\u5219\u7684\u6570\u636e\u7c7b\u578b\u7684\u8868\u8fbe\u5f0f\u90fd\u6709\u4e00\u4e2a\u6392\u5e8f\u89c4\u5219\u3002\uff08\u5185\u7f6e\u7684\u652f\u6301\u6392\u5e8f\u89c4\u5219\u7684\u6570\u636e\u7c7b\u578b\u5305\u62ec <code>text</code>\u3001<code>varchar</code> \u548c <code>char</code>\u3002\u7528\u6237\u5b9a\u4e49\u7684\u57fa\u7840\u7c7b\u578b\u4e5f\u53ef\u4ee5\u6807\u8bb0\u4e3a\u652f\u6301\u6392\u5e8f\u89c4\u5219\uff0c\u5f53\u7136\uff0c\u5efa\u7acb\u5728\u652f\u6301\u6392\u5e8f\u89c4\u5219\u7684\u6570\u636e\u7c7b\u578b\u4e4b\u4e0a\u7684<a href=\"/zh/docs/18/glossary.html#GLOSSARY-DOMAIN\" rel=\"nofollow\"><em></em></a><em><a href=\"/zh/docs/18/glossary.html#GLOSSARY-DOMAIN\" rel=\"nofollow\">\u57df</a></em>\u4e5f\u652f\u6301\u6392\u5e8f\u89c4\u5219\u3002\uff09\u5982\u679c\u8868\u8fbe\u5f0f\u662f\u5217\u5f15\u7528\uff0c\u5219\u8be5\u8868\u8fbe\u5f0f\u7684\u6392\u5e8f\u89c4\u5219\u5c31\u662f\u8be5\u5217\u5b9a\u4e49\u7684\u6392\u5e8f\u89c4\u5219\u3002\u5982\u679c\u8868\u8fbe\u5f0f\u662f\u5e38\u91cf\uff0c\u5219\u5176\u6392\u5e8f\u89c4\u5219\u5c31\u662f\u8be5\u5e38\u91cf\u6570\u636e\u7c7b\u578b\u7684\u9ed8\u8ba4\u6392\u5e8f\u89c4\u5219\u3002\u66f4\u590d\u6742\u8868\u8fbe\u5f0f\u7684\u6392\u5e8f\u89c4\u5219\u5219\u6309\u4e0b\u6587\u6240\u8ff0\uff0c\u4ece\u5176\u8f93\u5165\u8868\u8fbe\u5f0f\u7684\u6392\u5e8f\u89c4\u5219\u63a8\u5bfc\u51fa\u6765\u3002\n   </p><p>\n    \u8868\u8fbe\u5f0f\u7684\u6392\u5e8f\u89c4\u5219\u53ef\u4ee5\u662f<span>\u201c<span>\u9ed8\u8ba4</span>\u201d</span>\u6392\u5e8f\u89c4\u5219\uff0c\u8fd9\u8868\u793a\u4e3a\u6570\u636e\u5e93\u5b9a\u4e49\u7684\u533a\u57df\u8bbe\u7f6e\u3002\u8868\u8fbe\u5f0f\u7684\u6392\u5e8f\u89c4\u5219\u4e5f\u53ef\u80fd\u662f\u4e0d\u786e\u5b9a\u7684\u3002\u5728\u8fd9\u79cd\u60c5\u51b5\u4e0b\uff0c\u6392\u5e8f\u64cd\u4f5c\u4ee5\u53ca\u5176\u4ed6\u9700\u8981\u77e5\u9053\u6392\u5e8f\u89c4\u5219\u7684\u64cd\u4f5c\u90fd\u4f1a\u5931\u8d25\u3002\n   </p><p>\n    \u5f53\u6570\u636e\u5e93\u7cfb\u7edf\u5fc5\u987b\u6267\u884c\u6392\u5e8f\u6216\u5b57\u7b26\u5206\u7c7b\u65f6\uff0c\u5b83\u4f1a\u4f7f\u7528\u8f93\u5165\u8868\u8fbe\u5f0f\u7684\u6392\u5e8f\u89c4\u5219\u3002\u4f8b\u5982\uff0c\u8fd9\u4f1a\u53d1\u751f\u5728 <code>ORDER BY</code> \u5b50\u53e5\u4ee5\u53ca\u51fd\u6570\u6216\u64cd\u4f5c\u7b26\u8c03\u7528\uff08\u5982\n    <code>&lt;</code>\uff09\u4e2d\u3002\u5e94\u7528\u4e8e <code>ORDER BY</code> \u5b50\u53e5\u7684\u6392\u5e8f\u89c4\u5219\u5c31\u662f\u6392\u5e8f\u952e\u7684\u6392\u5e8f\u89c4\u5219\u3002\u5e94\u7528\u4e8e\u51fd\u6570\u6216\u64cd\u4f5c\u7b26\u8c03\u7528\u7684\u6392\u5e8f\u89c4\u5219\u5219\u6309\u4e0b\u6587\u6240\u8ff0\uff0c\u4ece\u53c2\u6570\u4e2d\u63a8\u5bfc\u51fa\u6765\u3002\u9664\u4e86\u6bd4\u8f83\u64cd\u4f5c\u7b26\u4e4b\u5916\uff0c\u5728\u5927\u5c0f\u5199\u4e4b\u95f4\u8fdb\u884c\u8f6c\u6362\u7684\u51fd\u6570\uff08\u4f8b\u5982 <code>lower</code>\u3001<code>upper</code> \u548c\n    <code>initcap</code>\uff09\u3001\u6a21\u5f0f\u5339\u914d\u64cd\u4f5c\u7b26\uff0c\u4ee5\u53ca <code>to_char</code>\n    \u53ca\u76f8\u5173\u51fd\u6570\uff0c\u4e5f\u90fd\u4f1a\u8003\u8651\u6392\u5e8f\u89c4\u5219\u3002\n   </p><p>\n    \u5bf9\u4e8e\u51fd\u6570\u6216\u64cd\u4f5c\u7b26\u8c03\u7528\uff0c\u901a\u8fc7\u68c0\u67e5\u53c2\u6570\u6392\u5e8f\u89c4\u5219\u63a8\u5bfc\u51fa\u7684\u6392\u5e8f\u89c4\u5219\uff0c\u4f1a\u5728\u8fd0\u884c\u65f6\u7528\u4e8e\u6267\u884c\u6307\u5b9a\u64cd\u4f5c\u3002\u5982\u679c\u8be5\u51fd\u6570\u6216\u64cd\u4f5c\u7b26\u8c03\u7528\u7684\u7ed3\u679c\u5c5e\u4e8e\u652f\u6301\u6392\u5e8f\u89c4\u5219\u7684\u6570\u636e\u7c7b\u578b\uff0c\u90a3\u4e48\u5728\u89e3\u6790\u65f6\u5b83\u4e5f\u4f1a\u88ab\u7528\u4f5c\u8be5\u51fd\u6570\u6216\u64cd\u4f5c\u7b26\u8868\u8fbe\u5f0f\u7684\u5df2\u5b9a\u4e49\u6392\u5e8f\u89c4\u5219\uff0c\u4ee5\u4fbf\u5728\u5916\u56f4\u8868\u8fbe\u5f0f\u9700\u8981\u77e5\u9053\u5176\u6392\u5e8f\u89c4\u5219\u65f6\u4f7f\u7528\u3002\n   </p><p><a href=\"/zh/docs/18/collation.html#COLLATION-CONCEPTS\" rel=\"nofollow\">\u67e5\u770b\u5b8c\u6574\u4e2d\u6587\u624b\u518c\u4e0e\u4e0a\u4e0b\u6587</a>\u3002</p>", "body_sha256": "ee0f6c082cd6ce71d65f820ffe057383cacff664d0672dc65d6c33f646f8b0c1", "content_hash": "387483eca2a1d74c471b9c7c24de04e29af1e3459dc81a74718c821ca634b2a1", "source_database": "center", "source_revision": "555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f"}, "signature": "", "tables_zh": [], "attributes": {"scope": "Source provider identity; installation/build availability is separate", "provider": "builtin", "catalog_code": "b"}, "description": ["\u6392\u5e8f\u89c4\u5219\u4e0e\u7f16\u7801 provider-builtin\u3002"], "manual_html": "", "manual_path": "/docs/18/collation.html#COLLATION-CONCEPTS", "sections_zh": [], "localization": {"status": "complete", "sources": [{"url": "/docs/18/collation.html", "method": "same-major semantic node", "sha256": "4fa99946c7c01ec3872b49a1fa92cadcd30d5a34d425829f836674d5c63b571a", "language": "zh", "matched_nodes": ["#COLLATION/div[1]/dl[0]/dt[0]", "#COLLATION/div[4]/div[6]/ol[0]/li[0]", "#COLLATION/div[4]/div[6]/ol[0]/li[1]", "#COLLATION/div[4]/div[6]/ol[0]/li[2]", "#COLLATION/div[4]/p[11]", "#COLLATION/div[4]/p[13]", "#COLLATION/div[4]/p[15]", "#COLLATION/div[4]/p[17]", "#COLLATION/div[4]/p[19]", "#COLLATION/div[4]/p[1]", "#COLLATION/div[4]/p[21]", "#COLLATION/div[4]/p[22]", "#COLLATION/div[4]/p[24]", "#COLLATION/div[4]/p[26]", "#COLLATION/div[4]/p[2]", "#COLLATION/div[4]/p[3]", "#COLLATION/div[4]/p[4]", "#COLLATION/div[4]/p[5]", "#COLLATION/div[4]/p[7]", "#COLLATION/div[4]/p[9]"]}], "language": "zh", "original_text": {"/versions/18/description/0": "builtin collation provider.", "/versions/18/facts/0/label": "Provider", "/versions/18/facts/1/label": "Catalog code", "/versions/18/facts/2/label": "Scope", "/versions/18/facts/2/value": "Source provider identity; installation/build availability is separate"}, "fallback_fields": [], "source_language": "en", "original_snapshot_sha256": "f54ac7d1c33504a93ebfb570406cdab96f733288e878d9095544e490da7c7bf1", "canonical_center_text_hash": "387483eca2a1d74c471b9c7c24de04e29af1e3459dc81a74718c821ca634b2a1"}, "description_zh": "\u6392\u5e8f\u89c4\u5219\u4e0e\u7f16\u7801 provider-builtin\u3002", "comparison_data": {"scope": "Source provider identity; installation/build availability is separate", "provider": "builtin", "catalog_code": "b"}, "comparison_hash": "d0ee87b3545cc68aafaa491d16e6d3a73ddc2ded39dd20ba234b922cd06fd397", "manual_language": "zh", "description_zh_html": "<p>\u6392\u5e8f\u89c4\u5219\u4e0e\u7f16\u7801 provider-builtin\u3002</p><dl><dt>\u9002\u7528\u8303\u56f4</dt><dd><code>Source provider identity; installation/build availability is separate</code></dd></dl><h3>\u540c\u7248\u672c\u4e2d\u6587\u624b\u518c\u8282\u9009</h3><p>\n    \u4ece\u6982\u5ff5\u4e0a\u8bb2\uff0c\u6bcf\u4e2a\u652f\u6301\u6392\u5e8f\u89c4\u5219\u7684\u6570\u636e\u7c7b\u578b\u7684\u8868\u8fbe\u5f0f\u90fd\u6709\u4e00\u4e2a\u6392\u5e8f\u89c4\u5219\u3002\uff08\u5185\u7f6e\u7684\u652f\u6301\u6392\u5e8f\u89c4\u5219\u7684\u6570\u636e\u7c7b\u578b\u5305\u62ec <code>text</code>\u3001<code>varchar</code> \u548c <code>char</code>\u3002\u7528\u6237\u5b9a\u4e49\u7684\u57fa\u7840\u7c7b\u578b\u4e5f\u53ef\u4ee5\u6807\u8bb0\u4e3a\u652f\u6301\u6392\u5e8f\u89c4\u5219\uff0c\u5f53\u7136\uff0c\u5efa\u7acb\u5728\u652f\u6301\u6392\u5e8f\u89c4\u5219\u7684\u6570\u636e\u7c7b\u578b\u4e4b\u4e0a\u7684<a href=\"/zh/docs/18/glossary.html#GLOSSARY-DOMAIN\" rel=\"nofollow\"><em></em></a><em><a href=\"/zh/docs/18/glossary.html#GLOSSARY-DOMAIN\" rel=\"nofollow\">\u57df</a></em>\u4e5f\u652f\u6301\u6392\u5e8f\u89c4\u5219\u3002\uff09\u5982\u679c\u8868\u8fbe\u5f0f\u662f\u5217\u5f15\u7528\uff0c\u5219\u8be5\u8868\u8fbe\u5f0f\u7684\u6392\u5e8f\u89c4\u5219\u5c31\u662f\u8be5\u5217\u5b9a\u4e49\u7684\u6392\u5e8f\u89c4\u5219\u3002\u5982\u679c\u8868\u8fbe\u5f0f\u662f\u5e38\u91cf\uff0c\u5219\u5176\u6392\u5e8f\u89c4\u5219\u5c31\u662f\u8be5\u5e38\u91cf\u6570\u636e\u7c7b\u578b\u7684\u9ed8\u8ba4\u6392\u5e8f\u89c4\u5219\u3002\u66f4\u590d\u6742\u8868\u8fbe\u5f0f\u7684\u6392\u5e8f\u89c4\u5219\u5219\u6309\u4e0b\u6587\u6240\u8ff0\uff0c\u4ece\u5176\u8f93\u5165\u8868\u8fbe\u5f0f\u7684\u6392\u5e8f\u89c4\u5219\u63a8\u5bfc\u51fa\u6765\u3002\n   </p><p>\n    \u8868\u8fbe\u5f0f\u7684\u6392\u5e8f\u89c4\u5219\u53ef\u4ee5\u662f<span>\u201c<span>\u9ed8\u8ba4</span>\u201d</span>\u6392\u5e8f\u89c4\u5219\uff0c\u8fd9\u8868\u793a\u4e3a\u6570\u636e\u5e93\u5b9a\u4e49\u7684\u533a\u57df\u8bbe\u7f6e\u3002\u8868\u8fbe\u5f0f\u7684\u6392\u5e8f\u89c4\u5219\u4e5f\u53ef\u80fd\u662f\u4e0d\u786e\u5b9a\u7684\u3002\u5728\u8fd9\u79cd\u60c5\u51b5\u4e0b\uff0c\u6392\u5e8f\u64cd\u4f5c\u4ee5\u53ca\u5176\u4ed6\u9700\u8981\u77e5\u9053\u6392\u5e8f\u89c4\u5219\u7684\u64cd\u4f5c\u90fd\u4f1a\u5931\u8d25\u3002\n   </p><p>\n    \u5f53\u6570\u636e\u5e93\u7cfb\u7edf\u5fc5\u987b\u6267\u884c\u6392\u5e8f\u6216\u5b57\u7b26\u5206\u7c7b\u65f6\uff0c\u5b83\u4f1a\u4f7f\u7528\u8f93\u5165\u8868\u8fbe\u5f0f\u7684\u6392\u5e8f\u89c4\u5219\u3002\u4f8b\u5982\uff0c\u8fd9\u4f1a\u53d1\u751f\u5728 <code>ORDER BY</code> \u5b50\u53e5\u4ee5\u53ca\u51fd\u6570\u6216\u64cd\u4f5c\u7b26\u8c03\u7528\uff08\u5982\n    <code>&lt;</code>\uff09\u4e2d\u3002\u5e94\u7528\u4e8e <code>ORDER BY</code> \u5b50\u53e5\u7684\u6392\u5e8f\u89c4\u5219\u5c31\u662f\u6392\u5e8f\u952e\u7684\u6392\u5e8f\u89c4\u5219\u3002\u5e94\u7528\u4e8e\u51fd\u6570\u6216\u64cd\u4f5c\u7b26\u8c03\u7528\u7684\u6392\u5e8f\u89c4\u5219\u5219\u6309\u4e0b\u6587\u6240\u8ff0\uff0c\u4ece\u53c2\u6570\u4e2d\u63a8\u5bfc\u51fa\u6765\u3002\u9664\u4e86\u6bd4\u8f83\u64cd\u4f5c\u7b26\u4e4b\u5916\uff0c\u5728\u5927\u5c0f\u5199\u4e4b\u95f4\u8fdb\u884c\u8f6c\u6362\u7684\u51fd\u6570\uff08\u4f8b\u5982 <code>lower</code>\u3001<code>upper</code> \u548c\n    <code>initcap</code>\uff09\u3001\u6a21\u5f0f\u5339\u914d\u64cd\u4f5c\u7b26\uff0c\u4ee5\u53ca <code>to_char</code>\n    \u53ca\u76f8\u5173\u51fd\u6570\uff0c\u4e5f\u90fd\u4f1a\u8003\u8651\u6392\u5e8f\u89c4\u5219\u3002\n   </p><p>\n    \u5bf9\u4e8e\u51fd\u6570\u6216\u64cd\u4f5c\u7b26\u8c03\u7528\uff0c\u901a\u8fc7\u68c0\u67e5\u53c2\u6570\u6392\u5e8f\u89c4\u5219\u63a8\u5bfc\u51fa\u7684\u6392\u5e8f\u89c4\u5219\uff0c\u4f1a\u5728\u8fd0\u884c\u65f6\u7528\u4e8e\u6267\u884c\u6307\u5b9a\u64cd\u4f5c\u3002\u5982\u679c\u8be5\u51fd\u6570\u6216\u64cd\u4f5c\u7b26\u8c03\u7528\u7684\u7ed3\u679c\u5c5e\u4e8e\u652f\u6301\u6392\u5e8f\u89c4\u5219\u7684\u6570\u636e\u7c7b\u578b\uff0c\u90a3\u4e48\u5728\u89e3\u6790\u65f6\u5b83\u4e5f\u4f1a\u88ab\u7528\u4f5c\u8be5\u51fd\u6570\u6216\u64cd\u4f5c\u7b26\u8868\u8fbe\u5f0f\u7684\u5df2\u5b9a\u4e49\u6392\u5e8f\u89c4\u5219\uff0c\u4ee5\u4fbf\u5728\u5916\u56f4\u8868\u8fbe\u5f0f\u9700\u8981\u77e5\u9053\u5176\u6392\u5e8f\u89c4\u5219\u65f6\u4f7f\u7528\u3002\n   </p><p><a href=\"/zh/docs/18/collation.html#COLLATION-CONCEPTS\" rel=\"nofollow\">\u67e5\u770b\u5b8c\u6574\u4e2d\u6587\u624b\u518c\u4e0e\u4e0a\u4e0b\u6587</a>\u3002</p>", "center_zh_rendered": "<p>\u6392\u5e8f\u89c4\u5219\u4e0e\u7f16\u7801 provider-builtin\u3002</p><dl><dt>\u9002\u7528\u8303\u56f4</dt><dd><code>Source provider identity; installation/build availability is separate</code></dd></dl><h3>\u540c\u7248\u672c\u4e2d\u6587\u624b\u518c\u8282\u9009</h3><p>\n    \u4ece\u6982\u5ff5\u4e0a\u8bb2\uff0c\u6bcf\u4e2a\u652f\u6301\u6392\u5e8f\u89c4\u5219\u7684\u6570\u636e\u7c7b\u578b\u7684\u8868\u8fbe\u5f0f\u90fd\u6709\u4e00\u4e2a\u6392\u5e8f\u89c4\u5219\u3002\uff08\u5185\u7f6e\u7684\u652f\u6301\u6392\u5e8f\u89c4\u5219\u7684\u6570\u636e\u7c7b\u578b\u5305\u62ec <code>text</code>\u3001<code>varchar</code> \u548c <code>char</code>\u3002\u7528\u6237\u5b9a\u4e49\u7684\u57fa\u7840\u7c7b\u578b\u4e5f\u53ef\u4ee5\u6807\u8bb0\u4e3a\u652f\u6301\u6392\u5e8f\u89c4\u5219\uff0c\u5f53\u7136\uff0c\u5efa\u7acb\u5728\u652f\u6301\u6392\u5e8f\u89c4\u5219\u7684\u6570\u636e\u7c7b\u578b\u4e4b\u4e0a\u7684<a href=\"/docs/18/glossary.html#GLOSSARY-DOMAIN\"><em></em></a><em><a href=\"/docs/18/glossary.html#GLOSSARY-DOMAIN\">\u57df</a></em>\u4e5f\u652f\u6301\u6392\u5e8f\u89c4\u5219\u3002\uff09\u5982\u679c\u8868\u8fbe\u5f0f\u662f\u5217\u5f15\u7528\uff0c\u5219\u8be5\u8868\u8fbe\u5f0f\u7684\u6392\u5e8f\u89c4\u5219\u5c31\u662f\u8be5\u5217\u5b9a\u4e49\u7684\u6392\u5e8f\u89c4\u5219\u3002\u5982\u679c\u8868\u8fbe\u5f0f\u662f\u5e38\u91cf\uff0c\u5219\u5176\u6392\u5e8f\u89c4\u5219\u5c31\u662f\u8be5\u5e38\u91cf\u6570\u636e\u7c7b\u578b\u7684\u9ed8\u8ba4\u6392\u5e8f\u89c4\u5219\u3002\u66f4\u590d\u6742\u8868\u8fbe\u5f0f\u7684\u6392\u5e8f\u89c4\u5219\u5219\u6309\u4e0b\u6587\u6240\u8ff0\uff0c\u4ece\u5176\u8f93\u5165\u8868\u8fbe\u5f0f\u7684\u6392\u5e8f\u89c4\u5219\u63a8\u5bfc\u51fa\u6765\u3002\n   </p><p>\n    \u8868\u8fbe\u5f0f\u7684\u6392\u5e8f\u89c4\u5219\u53ef\u4ee5\u662f<span>\u201c<span>\u9ed8\u8ba4</span>\u201d</span>\u6392\u5e8f\u89c4\u5219\uff0c\u8fd9\u8868\u793a\u4e3a\u6570\u636e\u5e93\u5b9a\u4e49\u7684\u533a\u57df\u8bbe\u7f6e\u3002\u8868\u8fbe\u5f0f\u7684\u6392\u5e8f\u89c4\u5219\u4e5f\u53ef\u80fd\u662f\u4e0d\u786e\u5b9a\u7684\u3002\u5728\u8fd9\u79cd\u60c5\u51b5\u4e0b\uff0c\u6392\u5e8f\u64cd\u4f5c\u4ee5\u53ca\u5176\u4ed6\u9700\u8981\u77e5\u9053\u6392\u5e8f\u89c4\u5219\u7684\u64cd\u4f5c\u90fd\u4f1a\u5931\u8d25\u3002\n   </p><p>\n    \u5f53\u6570\u636e\u5e93\u7cfb\u7edf\u5fc5\u987b\u6267\u884c\u6392\u5e8f\u6216\u5b57\u7b26\u5206\u7c7b\u65f6\uff0c\u5b83\u4f1a\u4f7f\u7528\u8f93\u5165\u8868\u8fbe\u5f0f\u7684\u6392\u5e8f\u89c4\u5219\u3002\u4f8b\u5982\uff0c\u8fd9\u4f1a\u53d1\u751f\u5728 <code>ORDER BY</code> \u5b50\u53e5\u4ee5\u53ca\u51fd\u6570\u6216\u64cd\u4f5c\u7b26\u8c03\u7528\uff08\u5982\n    <code>&lt;</code>\uff09\u4e2d\u3002\u5e94\u7528\u4e8e <code>ORDER BY</code> \u5b50\u53e5\u7684\u6392\u5e8f\u89c4\u5219\u5c31\u662f\u6392\u5e8f\u952e\u7684\u6392\u5e8f\u89c4\u5219\u3002\u5e94\u7528\u4e8e\u51fd\u6570\u6216\u64cd\u4f5c\u7b26\u8c03\u7528\u7684\u6392\u5e8f\u89c4\u5219\u5219\u6309\u4e0b\u6587\u6240\u8ff0\uff0c\u4ece\u53c2\u6570\u4e2d\u63a8\u5bfc\u51fa\u6765\u3002\u9664\u4e86\u6bd4\u8f83\u64cd\u4f5c\u7b26\u4e4b\u5916\uff0c\u5728\u5927\u5c0f\u5199\u4e4b\u95f4\u8fdb\u884c\u8f6c\u6362\u7684\u51fd\u6570\uff08\u4f8b\u5982 <code>lower</code>\u3001<code>upper</code> \u548c\n    <code>initcap</code>\uff09\u3001\u6a21\u5f0f\u5339\u914d\u64cd\u4f5c\u7b26\uff0c\u4ee5\u53ca <code>to_char</code>\n    \u53ca\u76f8\u5173\u51fd\u6570\uff0c\u4e5f\u90fd\u4f1a\u8003\u8651\u6392\u5e8f\u89c4\u5219\u3002\n   </p><p>\n    \u5bf9\u4e8e\u51fd\u6570\u6216\u64cd\u4f5c\u7b26\u8c03\u7528\uff0c\u901a\u8fc7\u68c0\u67e5\u53c2\u6570\u6392\u5e8f\u89c4\u5219\u63a8\u5bfc\u51fa\u7684\u6392\u5e8f\u89c4\u5219\uff0c\u4f1a\u5728\u8fd0\u884c\u65f6\u7528\u4e8e\u6267\u884c\u6307\u5b9a\u64cd\u4f5c\u3002\u5982\u679c\u8be5\u51fd\u6570\u6216\u64cd\u4f5c\u7b26\u8c03\u7528\u7684\u7ed3\u679c\u5c5e\u4e8e\u652f\u6301\u6392\u5e8f\u89c4\u5219\u7684\u6570\u636e\u7c7b\u578b\uff0c\u90a3\u4e48\u5728\u89e3\u6790\u65f6\u5b83\u4e5f\u4f1a\u88ab\u7528\u4f5c\u8be5\u51fd\u6570\u6216\u64cd\u4f5c\u7b26\u8868\u8fbe\u5f0f\u7684\u5df2\u5b9a\u4e49\u6392\u5e8f\u89c4\u5219\uff0c\u4ee5\u4fbf\u5728\u5916\u56f4\u8868\u8fbe\u5f0f\u9700\u8981\u77e5\u9053\u5176\u6392\u5e8f\u89c4\u5219\u65f6\u4f7f\u7528\u3002\n   </p><p><a href=\"/docs/18/collation.html#COLLATION-CONCEPTS\">\u67e5\u770b\u5b8c\u6574\u4e2d\u6587\u624b\u518c\u4e0e\u4e0a\u4e0b\u6587</a>\u3002</p>"}, "19": {"facts": [{"label": "\u63d0\u4f9b\u8005", "value": "builtin"}, {"label": "\u76ee\u5f55\u4ee3\u7801", "value": "b"}, {"label": "\u8303\u56f4", "value": "\u6e90\u7801\u4e2d\u7684\u63d0\u4f9b\u8005\u6807\u8bc6\uff1b\u5b89\u88c5\u6216\u6784\u5efa\u4e2d\u662f\u5426\u53ef\u7528\u53e6\u884c\u5224\u65ad"}], "tables": [], "aliases": [], "related": [], "release": {"ref": "https://ftp.postgresql.org/pub/source/v19rc1/postgresql-19rc1.tar.bz2", "label": "19rc1", "major": "19", "channel": "preview", "revision": "af105fc8e960fc836a09fc2cd7f582b49fd17675d9d36631abe3a565bfd7d701", "source_sha256": "af105fc8e960fc836a09fc2cd7f582b49fd17675d9d36631abe3a565bfd7d701", "catalog_fingerprint": "62fbf1a3689dbe8bf7e6b3372cfe6fbf867581427b3858a94c8419b77a4d2d1d"}, "sources": [{"url": "https://ftp.postgresql.org/pub/source/v19rc1/postgresql-19rc1.tar.bz2", "label": "Matching PostgreSQL source archive", "sha256": "af105fc8e960fc836a09fc2cd7f582b49fd17675d9d36631abe3a565bfd7d701"}, {"url": "/docs/19/collation.html#COLLATION-CONCEPTS", "path": "collation.html", "label": "PostgreSQL 19 English manual", "sha256": "76297e8354bd8ad0405f832c0c7fa24c9460b22dada76025e9d99f93ec0ac0c5"}], "zh_from": {"kind": "same-version-chinese-manual-with-source-derived-structured-summary", "manual": {"url": "/zh/docs/19/collation.html#COLLATION-CONCEPTS", "anchor": "COLLATION-CONCEPTS", "locale": "zh-Hans", "version": "19", "build_id": 109, "page_key": "collation.html", "extraction": "concept-introduction", "source_hash": "8f8820359c2aecf369e22e076f34aada3182cde24921b7855c7d5535953257ec", "fragment_sha256": "a02fdf6472773dff18ce4d034287dc1af98aed8a5cc657082171cfbb5a8de13a", "source_revision": "sha256:af105fc8e960fc836a09fc2cd7f582b49fd17675d9d36631abe3a565bfd7d701", "translation_revision": "git:b1b500221dbe5437cfca004d6b04d3f6e422765d;html-sha256:65fda1f1b62a89992b84014c9157e61b67dbe8190e93945826efec668fad038c", "translated_from_revision": "sha256:af105fc8e960fc836a09fc2cd7f582b49fd17675d9d36631abe3a565bfd7d701"}, "body_sha256": "0485936781c0308d23e3b68c5be2b6f3a0f13f39436851a00e2536845c58b49d", "runtime_rerun": false, "authored_translation": "source-derived-structured-summary", "source_facts_revision": "af105fc8e960fc836a09fc2cd7f582b49fd17675d9d36631abe3a565bfd7d701"}, "facts_zh": [{"label": "\u63d0\u4f9b\u8005", "value": "builtin"}, {"label": "\u76ee\u5f55\u4ee3\u7801", "value": "b"}, {"label": "\u8303\u56f4", "value": "\u6e90\u7801\u4e2d\u7684\u63d0\u4f9b\u8005\u6807\u8bc6\uff1b\u5b89\u88c5\u6216\u6784\u5efa\u4e2d\u662f\u5426\u53ef\u7528\u53e6\u884c\u5224\u65ad"}], "sections": [], "center_zh": {"title": "builtin", "locale": "zh-Hans", "source": {"key": "provider-builtin", "locale": "zh-Hans", "version": "19", "text_hash": "dfee5af4d438f0cb4fb60e554ad81be2c0b4be35e2d551d2efa2036d173c9989", "collection": "locale", "dataset_hash": "7c31b524dfe136022d39a6ae8dcfac6b3bbd5f8fdaf422536599981252aff0c9", "source_database": "center", "source_revision": "af105fc8e960fc836a09fc2cd7f582b49fd17675d9d36631abe3a565bfd7d701"}, "payload": {"facts": [{"label": "\u63d0\u4f9b\u8005", "value": "builtin"}, {"label": "\u76ee\u5f55\u4ee3\u7801", "value": "b"}, {"label": "\u8303\u56f4", "value": "\u6e90\u7801\u4e2d\u7684\u63d0\u4f9b\u8005\u6807\u8bc6\uff1b\u5b89\u88c5\u6216\u6784\u5efa\u4e2d\u662f\u5426\u53ef\u7528\u53e6\u884c\u5224\u65ad"}], "tables": [], "zh_from": {"kind": "same-version-chinese-manual-with-source-derived-structured-summary", "manual": {"url": "/zh/docs/19/collation.html#COLLATION-CONCEPTS", "anchor": "COLLATION-CONCEPTS", "locale": "zh-Hans", "version": "19", "build_id": 109, "page_key": "collation.html", "extraction": "concept-introduction", "source_hash": "8f8820359c2aecf369e22e076f34aada3182cde24921b7855c7d5535953257ec", "fragment_sha256": "a02fdf6472773dff18ce4d034287dc1af98aed8a5cc657082171cfbb5a8de13a", "source_revision": "sha256:af105fc8e960fc836a09fc2cd7f582b49fd17675d9d36631abe3a565bfd7d701", "translation_revision": "git:b1b500221dbe5437cfca004d6b04d3f6e422765d;html-sha256:65fda1f1b62a89992b84014c9157e61b67dbe8190e93945826efec668fad038c", "translated_from_revision": "sha256:af105fc8e960fc836a09fc2cd7f582b49fd17675d9d36631abe3a565bfd7d701"}, "body_sha256": "0485936781c0308d23e3b68c5be2b6f3a0f13f39436851a00e2536845c58b49d", "runtime_rerun": false, "authored_translation": "source-derived-structured-summary", "source_facts_revision": "af105fc8e960fc836a09fc2cd7f582b49fd17675d9d36631abe3a565bfd7d701"}, "sections": [], "description_zh": "\u6392\u5e8f\u89c4\u5219\u4e0e\u7f16\u7801 provider-builtin\u3002", "description_zh_html": "<p>\u6392\u5e8f\u89c4\u5219\u4e0e\u7f16\u7801 provider-builtin\u3002</p><dl><dt>\u9002\u7528\u8303\u56f4</dt><dd><code>Source provider identity; installation/build availability is separate</code></dd></dl><h3>\u540c\u7248\u672c\u4e2d\u6587\u624b\u518c\u8282\u9009</h3><p>\n    \u4ece\u6982\u5ff5\u4e0a\u8bb2\uff0c\u6bcf\u4e2a\u652f\u6301\u6392\u5e8f\u89c4\u5219\u7684\u6570\u636e\u7c7b\u578b\u7684\u8868\u8fbe\u5f0f\u90fd\u6709\u4e00\u4e2a\u6392\u5e8f\u89c4\u5219\u3002\uff08\u5185\u7f6e\u7684\u652f\u6301\u6392\u5e8f\u89c4\u5219\u7684\u6570\u636e\u7c7b\u578b\u5305\u62ec <code class=\"type\">text</code>\u3001<code class=\"type\">varchar</code> \u548c <code class=\"type\">char</code>\u3002\u7528\u6237\u5b9a\u4e49\u7684\u57fa\u7840\u7c7b\u578b\u4e5f\u53ef\u4ee5\u6807\u8bb0\u4e3a\u652f\u6301\u6392\u5e8f\u89c4\u5219\uff0c\u5f53\u7136\uff0c\u5efa\u7acb\u5728\u652f\u6301\u6392\u5e8f\u89c4\u5219\u7684\u6570\u636e\u7c7b\u578b\u4e4b\u4e0a\u7684<a class=\"glossterm\" href=\"/zh/docs/19/glossary.html#GLOSSARY-DOMAIN\"><em class=\"glossterm\"></em></a><em class=\"glossterm\"><a class=\"glossterm\" href=\"/zh/docs/19/glossary.html#GLOSSARY-DOMAIN\">\u57df</a></em>\u4e5f\u652f\u6301\u6392\u5e8f\u89c4\u5219\u3002\uff09\u5982\u679c\u8868\u8fbe\u5f0f\u662f\u5217\u5f15\u7528\uff0c\u5219\u8be5\u8868\u8fbe\u5f0f\u7684\u6392\u5e8f\u89c4\u5219\u5c31\u662f\u8be5\u5217\u5b9a\u4e49\u7684\u6392\u5e8f\u89c4\u5219\u3002\u5982\u679c\u8868\u8fbe\u5f0f\u662f\u5e38\u91cf\uff0c\u5219\u5176\u6392\u5e8f\u89c4\u5219\u5c31\u662f\u8be5\u5e38\u91cf\u6570\u636e\u7c7b\u578b\u7684\u9ed8\u8ba4\u6392\u5e8f\u89c4\u5219\u3002\u66f4\u590d\u6742\u8868\u8fbe\u5f0f\u7684\u6392\u5e8f\u89c4\u5219\u5219\u6309\u4e0b\u6587\u6240\u8ff0\uff0c\u4ece\u5176\u8f93\u5165\u8868\u8fbe\u5f0f\u7684\u6392\u5e8f\u89c4\u5219\u63a8\u5bfc\u51fa\u6765\u3002\n   </p><p>\n    \u8868\u8fbe\u5f0f\u7684\u6392\u5e8f\u89c4\u5219\u53ef\u4ee5\u662f<span class=\"quote\">\u201c<span class=\"quote\">\u9ed8\u8ba4</span>\u201d</span>\u6392\u5e8f\u89c4\u5219\uff0c\u8fd9\u8868\u793a\u4e3a\u6570\u636e\u5e93\u5b9a\u4e49\u7684\u533a\u57df\u8bbe\u7f6e\u3002\u8868\u8fbe\u5f0f\u7684\u6392\u5e8f\u89c4\u5219\u4e5f\u53ef\u80fd\u662f\u4e0d\u786e\u5b9a\u7684\u3002\u5728\u8fd9\u79cd\u60c5\u51b5\u4e0b\uff0c\u6392\u5e8f\u64cd\u4f5c\u4ee5\u53ca\u5176\u4ed6\u9700\u8981\u77e5\u9053\u6392\u5e8f\u89c4\u5219\u7684\u64cd\u4f5c\u90fd\u4f1a\u5931\u8d25\u3002\n   </p><p>\n    \u5f53\u6570\u636e\u5e93\u7cfb\u7edf\u5fc5\u987b\u6267\u884c\u6392\u5e8f\u6216\u5b57\u7b26\u5206\u7c7b\u65f6\uff0c\u5b83\u4f1a\u4f7f\u7528\u8f93\u5165\u8868\u8fbe\u5f0f\u7684\u6392\u5e8f\u89c4\u5219\u3002\u4f8b\u5982\uff0c\u8fd9\u4f1a\u53d1\u751f\u5728 <code class=\"literal\">ORDER BY</code> \u5b50\u53e5\u4ee5\u53ca\u51fd\u6570\u6216\u64cd\u4f5c\u7b26\u8c03\u7528\uff08\u5982\n    <code class=\"literal\">&lt;</code>\uff09\u4e2d\u3002\u5e94\u7528\u4e8e <code class=\"literal\">ORDER BY</code> \u5b50\u53e5\u7684\u6392\u5e8f\u89c4\u5219\u5c31\u662f\u6392\u5e8f\u952e\u7684\u6392\u5e8f\u89c4\u5219\u3002\u5e94\u7528\u4e8e\u51fd\u6570\u6216\u64cd\u4f5c\u7b26\u8c03\u7528\u7684\u6392\u5e8f\u89c4\u5219\u5219\u6309\u4e0b\u6587\u6240\u8ff0\uff0c\u4ece\u53c2\u6570\u4e2d\u63a8\u5bfc\u51fa\u6765\u3002\u9664\u4e86\u6bd4\u8f83\u64cd\u4f5c\u7b26\u4e4b\u5916\uff0c\u5728\u5927\u5c0f\u5199\u4e4b\u95f4\u8fdb\u884c\u8f6c\u6362\u7684\u51fd\u6570\uff08\u4f8b\u5982 <code class=\"function\">lower</code>\u3001<code class=\"function\">upper</code> \u548c\n    <code class=\"function\">initcap</code>\uff09\u3001\u6a21\u5f0f\u5339\u914d\u64cd\u4f5c\u7b26\uff0c\u4ee5\u53ca <code class=\"function\">to_char</code>\n    \u53ca\u76f8\u5173\u51fd\u6570\uff0c\u4e5f\u90fd\u4f1a\u8003\u8651\u6392\u5e8f\u89c4\u5219\u3002\n   </p><p>\n    \u5bf9\u4e8e\u51fd\u6570\u6216\u64cd\u4f5c\u7b26\u8c03\u7528\uff0c\u901a\u8fc7\u68c0\u67e5\u53c2\u6570\u6392\u5e8f\u89c4\u5219\u63a8\u5bfc\u51fa\u7684\u6392\u5e8f\u89c4\u5219\uff0c\u4f1a\u5728\u8fd0\u884c\u65f6\u7528\u4e8e\u6267\u884c\u6307\u5b9a\u64cd\u4f5c\u3002\u5982\u679c\u8be5\u51fd\u6570\u6216\u64cd\u4f5c\u7b26\u8c03\u7528\u7684\u7ed3\u679c\u5c5e\u4e8e\u652f\u6301\u6392\u5e8f\u89c4\u5219\u7684\u6570\u636e\u7c7b\u578b\uff0c\u90a3\u4e48\u5728\u89e3\u6790\u65f6\u5b83\u4e5f\u4f1a\u88ab\u7528\u4f5c\u8be5\u51fd\u6570\u6216\u64cd\u4f5c\u7b26\u8868\u8fbe\u5f0f\u7684\u5df2\u5b9a\u4e49\u6392\u5e8f\u89c4\u5219\uff0c\u4ee5\u4fbf\u5728\u5916\u56f4\u8868\u8fbe\u5f0f\u9700\u8981\u77e5\u9053\u5176\u6392\u5e8f\u89c4\u5219\u65f6\u4f7f\u7528\u3002\n   </p><p><a href=\"/zh/docs/19/collation.html#COLLATION-CONCEPTS\">\u67e5\u770b\u5b8c\u6574\u4e2d\u6587\u624b\u518c\u4e0e\u4e0a\u4e0b\u6587</a>\u3002</p>"}, "summary": "\u6392\u5e8f\u89c4\u5219\u4e0e\u7f16\u7801 provider-builtin\u3002", "version": "19", "link_map": {"/zh/docs/19/glossary.html#GLOSSARY-DOMAIN": "/docs/19/glossary.html#GLOSSARY-DOMAIN", "/zh/docs/19/collation.html#COLLATION-CONCEPTS": "/docs/19/collation.html#COLLATION-CONCEPTS"}, "body_html": "<p>\u6392\u5e8f\u89c4\u5219\u4e0e\u7f16\u7801 provider-builtin\u3002</p><dl><dt>\u9002\u7528\u8303\u56f4</dt><dd><code>Source provider identity; installation/build availability is separate</code></dd></dl><h3>\u540c\u7248\u672c\u4e2d\u6587\u624b\u518c\u8282\u9009</h3><p>\n    \u4ece\u6982\u5ff5\u4e0a\u8bb2\uff0c\u6bcf\u4e2a\u652f\u6301\u6392\u5e8f\u89c4\u5219\u7684\u6570\u636e\u7c7b\u578b\u7684\u8868\u8fbe\u5f0f\u90fd\u6709\u4e00\u4e2a\u6392\u5e8f\u89c4\u5219\u3002\uff08\u5185\u7f6e\u7684\u652f\u6301\u6392\u5e8f\u89c4\u5219\u7684\u6570\u636e\u7c7b\u578b\u5305\u62ec <code>text</code>\u3001<code>varchar</code> \u548c <code>char</code>\u3002\u7528\u6237\u5b9a\u4e49\u7684\u57fa\u7840\u7c7b\u578b\u4e5f\u53ef\u4ee5\u6807\u8bb0\u4e3a\u652f\u6301\u6392\u5e8f\u89c4\u5219\uff0c\u5f53\u7136\uff0c\u5efa\u7acb\u5728\u652f\u6301\u6392\u5e8f\u89c4\u5219\u7684\u6570\u636e\u7c7b\u578b\u4e4b\u4e0a\u7684<a href=\"/zh/docs/19/glossary.html#GLOSSARY-DOMAIN\" rel=\"nofollow\"><em></em></a><em><a href=\"/zh/docs/19/glossary.html#GLOSSARY-DOMAIN\" rel=\"nofollow\">\u57df</a></em>\u4e5f\u652f\u6301\u6392\u5e8f\u89c4\u5219\u3002\uff09\u5982\u679c\u8868\u8fbe\u5f0f\u662f\u5217\u5f15\u7528\uff0c\u5219\u8be5\u8868\u8fbe\u5f0f\u7684\u6392\u5e8f\u89c4\u5219\u5c31\u662f\u8be5\u5217\u5b9a\u4e49\u7684\u6392\u5e8f\u89c4\u5219\u3002\u5982\u679c\u8868\u8fbe\u5f0f\u662f\u5e38\u91cf\uff0c\u5219\u5176\u6392\u5e8f\u89c4\u5219\u5c31\u662f\u8be5\u5e38\u91cf\u6570\u636e\u7c7b\u578b\u7684\u9ed8\u8ba4\u6392\u5e8f\u89c4\u5219\u3002\u66f4\u590d\u6742\u8868\u8fbe\u5f0f\u7684\u6392\u5e8f\u89c4\u5219\u5219\u6309\u4e0b\u6587\u6240\u8ff0\uff0c\u4ece\u5176\u8f93\u5165\u8868\u8fbe\u5f0f\u7684\u6392\u5e8f\u89c4\u5219\u63a8\u5bfc\u51fa\u6765\u3002\n   </p><p>\n    \u8868\u8fbe\u5f0f\u7684\u6392\u5e8f\u89c4\u5219\u53ef\u4ee5\u662f<span>\u201c<span>\u9ed8\u8ba4</span>\u201d</span>\u6392\u5e8f\u89c4\u5219\uff0c\u8fd9\u8868\u793a\u4e3a\u6570\u636e\u5e93\u5b9a\u4e49\u7684\u533a\u57df\u8bbe\u7f6e\u3002\u8868\u8fbe\u5f0f\u7684\u6392\u5e8f\u89c4\u5219\u4e5f\u53ef\u80fd\u662f\u4e0d\u786e\u5b9a\u7684\u3002\u5728\u8fd9\u79cd\u60c5\u51b5\u4e0b\uff0c\u6392\u5e8f\u64cd\u4f5c\u4ee5\u53ca\u5176\u4ed6\u9700\u8981\u77e5\u9053\u6392\u5e8f\u89c4\u5219\u7684\u64cd\u4f5c\u90fd\u4f1a\u5931\u8d25\u3002\n   </p><p>\n    \u5f53\u6570\u636e\u5e93\u7cfb\u7edf\u5fc5\u987b\u6267\u884c\u6392\u5e8f\u6216\u5b57\u7b26\u5206\u7c7b\u65f6\uff0c\u5b83\u4f1a\u4f7f\u7528\u8f93\u5165\u8868\u8fbe\u5f0f\u7684\u6392\u5e8f\u89c4\u5219\u3002\u4f8b\u5982\uff0c\u8fd9\u4f1a\u53d1\u751f\u5728 <code>ORDER BY</code> \u5b50\u53e5\u4ee5\u53ca\u51fd\u6570\u6216\u64cd\u4f5c\u7b26\u8c03\u7528\uff08\u5982\n    <code>&lt;</code>\uff09\u4e2d\u3002\u5e94\u7528\u4e8e <code>ORDER BY</code> \u5b50\u53e5\u7684\u6392\u5e8f\u89c4\u5219\u5c31\u662f\u6392\u5e8f\u952e\u7684\u6392\u5e8f\u89c4\u5219\u3002\u5e94\u7528\u4e8e\u51fd\u6570\u6216\u64cd\u4f5c\u7b26\u8c03\u7528\u7684\u6392\u5e8f\u89c4\u5219\u5219\u6309\u4e0b\u6587\u6240\u8ff0\uff0c\u4ece\u53c2\u6570\u4e2d\u63a8\u5bfc\u51fa\u6765\u3002\u9664\u4e86\u6bd4\u8f83\u64cd\u4f5c\u7b26\u4e4b\u5916\uff0c\u5728\u5927\u5c0f\u5199\u4e4b\u95f4\u8fdb\u884c\u8f6c\u6362\u7684\u51fd\u6570\uff08\u4f8b\u5982 <code>lower</code>\u3001<code>upper</code> \u548c\n    <code>initcap</code>\uff09\u3001\u6a21\u5f0f\u5339\u914d\u64cd\u4f5c\u7b26\uff0c\u4ee5\u53ca <code>to_char</code>\n    \u53ca\u76f8\u5173\u51fd\u6570\uff0c\u4e5f\u90fd\u4f1a\u8003\u8651\u6392\u5e8f\u89c4\u5219\u3002\n   </p><p>\n    \u5bf9\u4e8e\u51fd\u6570\u6216\u64cd\u4f5c\u7b26\u8c03\u7528\uff0c\u901a\u8fc7\u68c0\u67e5\u53c2\u6570\u6392\u5e8f\u89c4\u5219\u63a8\u5bfc\u51fa\u7684\u6392\u5e8f\u89c4\u5219\uff0c\u4f1a\u5728\u8fd0\u884c\u65f6\u7528\u4e8e\u6267\u884c\u6307\u5b9a\u64cd\u4f5c\u3002\u5982\u679c\u8be5\u51fd\u6570\u6216\u64cd\u4f5c\u7b26\u8c03\u7528\u7684\u7ed3\u679c\u5c5e\u4e8e\u652f\u6301\u6392\u5e8f\u89c4\u5219\u7684\u6570\u636e\u7c7b\u578b\uff0c\u90a3\u4e48\u5728\u89e3\u6790\u65f6\u5b83\u4e5f\u4f1a\u88ab\u7528\u4f5c\u8be5\u51fd\u6570\u6216\u64cd\u4f5c\u7b26\u8868\u8fbe\u5f0f\u7684\u5df2\u5b9a\u4e49\u6392\u5e8f\u89c4\u5219\uff0c\u4ee5\u4fbf\u5728\u5916\u56f4\u8868\u8fbe\u5f0f\u9700\u8981\u77e5\u9053\u5176\u6392\u5e8f\u89c4\u5219\u65f6\u4f7f\u7528\u3002\n   </p><p><a href=\"/zh/docs/19/collation.html#COLLATION-CONCEPTS\" rel=\"nofollow\">\u67e5\u770b\u5b8c\u6574\u4e2d\u6587\u624b\u518c\u4e0e\u4e0a\u4e0b\u6587</a>\u3002</p>", "body_sha256": "7503fc580b5137192f3063a3efffd5259eefabd3117e9925a37d522f534c1428", "content_hash": "dfee5af4d438f0cb4fb60e554ad81be2c0b4be35e2d551d2efa2036d173c9989", "source_database": "center", "source_revision": "af105fc8e960fc836a09fc2cd7f582b49fd17675d9d36631abe3a565bfd7d701"}, "signature": "", "tables_zh": [], "attributes": {"scope": "Source provider identity; installation/build availability is separate", "provider": "builtin", "catalog_code": "b"}, "description": ["\u6392\u5e8f\u89c4\u5219\u4e0e\u7f16\u7801 provider-builtin\u3002"], "manual_html": "", "manual_path": "/docs/19/collation.html#COLLATION-CONCEPTS", "sections_zh": [], "localization": {"status": "complete", "sources": [{"url": "/docs/19/collation.html", "method": "same-major semantic node", "sha256": "5f52d911c49ada8ebaf89c3bb635ee3e1065f3d39e9942830b32a92560bfba57", "language": "zh", "matched_nodes": ["#COLLATION/div[1]/dl[0]/dt[0]", "#COLLATION/div[4]/div[6]/ol[0]/li[0]", "#COLLATION/div[4]/div[6]/ol[0]/li[1]", "#COLLATION/div[4]/div[6]/ol[0]/li[2]", "#COLLATION/div[4]/p[11]", "#COLLATION/div[4]/p[13]", "#COLLATION/div[4]/p[15]", "#COLLATION/div[4]/p[17]", "#COLLATION/div[4]/p[19]", "#COLLATION/div[4]/p[1]", "#COLLATION/div[4]/p[21]", "#COLLATION/div[4]/p[22]", "#COLLATION/div[4]/p[24]", "#COLLATION/div[4]/p[26]", "#COLLATION/div[4]/p[2]", "#COLLATION/div[4]/p[3]", "#COLLATION/div[4]/p[4]", "#COLLATION/div[4]/p[5]", "#COLLATION/div[4]/p[7]", "#COLLATION/div[4]/p[9]"]}], "language": "zh", "original_text": {"/versions/19/description/0": "builtin collation provider.", "/versions/19/facts/0/label": "Provider", "/versions/19/facts/1/label": "Catalog code", "/versions/19/facts/2/label": "Scope", "/versions/19/facts/2/value": "Source provider identity; installation/build availability is separate"}, "fallback_fields": [], "source_language": "en", "original_snapshot_sha256": "98eb93801bf15090ac27271c67c93b80b547e400f4cedf2cb44de92a27aab034", "canonical_center_text_hash": "dfee5af4d438f0cb4fb60e554ad81be2c0b4be35e2d551d2efa2036d173c9989"}, "description_zh": "\u6392\u5e8f\u89c4\u5219\u4e0e\u7f16\u7801 provider-builtin\u3002", "comparison_data": {"scope": "Source provider identity; installation/build availability is separate", "provider": "builtin", "catalog_code": "b"}, "comparison_hash": "d0ee87b3545cc68aafaa491d16e6d3a73ddc2ded39dd20ba234b922cd06fd397", "manual_language": "zh", "description_zh_html": "<p>\u6392\u5e8f\u89c4\u5219\u4e0e\u7f16\u7801 provider-builtin\u3002</p><dl><dt>\u9002\u7528\u8303\u56f4</dt><dd><code>Source provider identity; installation/build availability is separate</code></dd></dl><h3>\u540c\u7248\u672c\u4e2d\u6587\u624b\u518c\u8282\u9009</h3><p>\n    \u4ece\u6982\u5ff5\u4e0a\u8bb2\uff0c\u6bcf\u4e2a\u652f\u6301\u6392\u5e8f\u89c4\u5219\u7684\u6570\u636e\u7c7b\u578b\u7684\u8868\u8fbe\u5f0f\u90fd\u6709\u4e00\u4e2a\u6392\u5e8f\u89c4\u5219\u3002\uff08\u5185\u7f6e\u7684\u652f\u6301\u6392\u5e8f\u89c4\u5219\u7684\u6570\u636e\u7c7b\u578b\u5305\u62ec <code>text</code>\u3001<code>varchar</code> \u548c <code>char</code>\u3002\u7528\u6237\u5b9a\u4e49\u7684\u57fa\u7840\u7c7b\u578b\u4e5f\u53ef\u4ee5\u6807\u8bb0\u4e3a\u652f\u6301\u6392\u5e8f\u89c4\u5219\uff0c\u5f53\u7136\uff0c\u5efa\u7acb\u5728\u652f\u6301\u6392\u5e8f\u89c4\u5219\u7684\u6570\u636e\u7c7b\u578b\u4e4b\u4e0a\u7684<a href=\"/zh/docs/19/glossary.html#GLOSSARY-DOMAIN\" rel=\"nofollow\"><em></em></a><em><a href=\"/zh/docs/19/glossary.html#GLOSSARY-DOMAIN\" rel=\"nofollow\">\u57df</a></em>\u4e5f\u652f\u6301\u6392\u5e8f\u89c4\u5219\u3002\uff09\u5982\u679c\u8868\u8fbe\u5f0f\u662f\u5217\u5f15\u7528\uff0c\u5219\u8be5\u8868\u8fbe\u5f0f\u7684\u6392\u5e8f\u89c4\u5219\u5c31\u662f\u8be5\u5217\u5b9a\u4e49\u7684\u6392\u5e8f\u89c4\u5219\u3002\u5982\u679c\u8868\u8fbe\u5f0f\u662f\u5e38\u91cf\uff0c\u5219\u5176\u6392\u5e8f\u89c4\u5219\u5c31\u662f\u8be5\u5e38\u91cf\u6570\u636e\u7c7b\u578b\u7684\u9ed8\u8ba4\u6392\u5e8f\u89c4\u5219\u3002\u66f4\u590d\u6742\u8868\u8fbe\u5f0f\u7684\u6392\u5e8f\u89c4\u5219\u5219\u6309\u4e0b\u6587\u6240\u8ff0\uff0c\u4ece\u5176\u8f93\u5165\u8868\u8fbe\u5f0f\u7684\u6392\u5e8f\u89c4\u5219\u63a8\u5bfc\u51fa\u6765\u3002\n   </p><p>\n    \u8868\u8fbe\u5f0f\u7684\u6392\u5e8f\u89c4\u5219\u53ef\u4ee5\u662f<span>\u201c<span>\u9ed8\u8ba4</span>\u201d</span>\u6392\u5e8f\u89c4\u5219\uff0c\u8fd9\u8868\u793a\u4e3a\u6570\u636e\u5e93\u5b9a\u4e49\u7684\u533a\u57df\u8bbe\u7f6e\u3002\u8868\u8fbe\u5f0f\u7684\u6392\u5e8f\u89c4\u5219\u4e5f\u53ef\u80fd\u662f\u4e0d\u786e\u5b9a\u7684\u3002\u5728\u8fd9\u79cd\u60c5\u51b5\u4e0b\uff0c\u6392\u5e8f\u64cd\u4f5c\u4ee5\u53ca\u5176\u4ed6\u9700\u8981\u77e5\u9053\u6392\u5e8f\u89c4\u5219\u7684\u64cd\u4f5c\u90fd\u4f1a\u5931\u8d25\u3002\n   </p><p>\n    \u5f53\u6570\u636e\u5e93\u7cfb\u7edf\u5fc5\u987b\u6267\u884c\u6392\u5e8f\u6216\u5b57\u7b26\u5206\u7c7b\u65f6\uff0c\u5b83\u4f1a\u4f7f\u7528\u8f93\u5165\u8868\u8fbe\u5f0f\u7684\u6392\u5e8f\u89c4\u5219\u3002\u4f8b\u5982\uff0c\u8fd9\u4f1a\u53d1\u751f\u5728 <code>ORDER BY</code> \u5b50\u53e5\u4ee5\u53ca\u51fd\u6570\u6216\u64cd\u4f5c\u7b26\u8c03\u7528\uff08\u5982\n    <code>&lt;</code>\uff09\u4e2d\u3002\u5e94\u7528\u4e8e <code>ORDER BY</code> \u5b50\u53e5\u7684\u6392\u5e8f\u89c4\u5219\u5c31\u662f\u6392\u5e8f\u952e\u7684\u6392\u5e8f\u89c4\u5219\u3002\u5e94\u7528\u4e8e\u51fd\u6570\u6216\u64cd\u4f5c\u7b26\u8c03\u7528\u7684\u6392\u5e8f\u89c4\u5219\u5219\u6309\u4e0b\u6587\u6240\u8ff0\uff0c\u4ece\u53c2\u6570\u4e2d\u63a8\u5bfc\u51fa\u6765\u3002\u9664\u4e86\u6bd4\u8f83\u64cd\u4f5c\u7b26\u4e4b\u5916\uff0c\u5728\u5927\u5c0f\u5199\u4e4b\u95f4\u8fdb\u884c\u8f6c\u6362\u7684\u51fd\u6570\uff08\u4f8b\u5982 <code>lower</code>\u3001<code>upper</code> \u548c\n    <code>initcap</code>\uff09\u3001\u6a21\u5f0f\u5339\u914d\u64cd\u4f5c\u7b26\uff0c\u4ee5\u53ca <code>to_char</code>\n    \u53ca\u76f8\u5173\u51fd\u6570\uff0c\u4e5f\u90fd\u4f1a\u8003\u8651\u6392\u5e8f\u89c4\u5219\u3002\n   </p><p>\n    \u5bf9\u4e8e\u51fd\u6570\u6216\u64cd\u4f5c\u7b26\u8c03\u7528\uff0c\u901a\u8fc7\u68c0\u67e5\u53c2\u6570\u6392\u5e8f\u89c4\u5219\u63a8\u5bfc\u51fa\u7684\u6392\u5e8f\u89c4\u5219\uff0c\u4f1a\u5728\u8fd0\u884c\u65f6\u7528\u4e8e\u6267\u884c\u6307\u5b9a\u64cd\u4f5c\u3002\u5982\u679c\u8be5\u51fd\u6570\u6216\u64cd\u4f5c\u7b26\u8c03\u7528\u7684\u7ed3\u679c\u5c5e\u4e8e\u652f\u6301\u6392\u5e8f\u89c4\u5219\u7684\u6570\u636e\u7c7b\u578b\uff0c\u90a3\u4e48\u5728\u89e3\u6790\u65f6\u5b83\u4e5f\u4f1a\u88ab\u7528\u4f5c\u8be5\u51fd\u6570\u6216\u64cd\u4f5c\u7b26\u8868\u8fbe\u5f0f\u7684\u5df2\u5b9a\u4e49\u6392\u5e8f\u89c4\u5219\uff0c\u4ee5\u4fbf\u5728\u5916\u56f4\u8868\u8fbe\u5f0f\u9700\u8981\u77e5\u9053\u5176\u6392\u5e8f\u89c4\u5219\u65f6\u4f7f\u7528\u3002\n   </p><p><a href=\"/zh/docs/19/collation.html#COLLATION-CONCEPTS\" rel=\"nofollow\">\u67e5\u770b\u5b8c\u6574\u4e2d\u6587\u624b\u518c\u4e0e\u4e0a\u4e0b\u6587</a>\u3002</p>", "source_revalidation": {"kind": "static-same-version-source-and-manual-replay", "audit": "wiki-audit-20261023", "runtime_rerun": false, "compared_fields": "entity membership and source-derived facts; presentation markup normalized", "source_revision": "af105fc8e960fc836a09fc2cd7f582b49fd17675d9d36631abe3a565bfd7d701", "previous_source_revision": "83157ee9c599d03b2f7a3d73ef3a56ec24e0e79cc2b3501a64d1364f56398c86"}}, "20": {"facts": [{"label": "\u63d0\u4f9b\u8005", "value": "builtin"}, {"label": "\u76ee\u5f55\u4ee3\u7801", "value": "b"}, {"label": "\u8303\u56f4", "value": "\u6e90\u7801\u4e2d\u7684\u63d0\u4f9b\u8005\u6807\u8bc6\uff1b\u5b89\u88c5\u6216\u6784\u5efa\u4e2d\u662f\u5426\u53ef\u7528\u53e6\u884c\u5224\u65ad"}], "tables": [], "aliases": [], "related": [], "release": {"ref": "https://ftp.postgresql.org/pub/snapshot/dev/postgresql-snapshot.tar.bz2", "label": "20devel", "major": "20", "channel": "devel", "revision": "49c73aa4c9cacef8ca979276a28ac416c08e9e54c9baee4ae5fd116a35fa13ac", "source_sha256": "49c73aa4c9cacef8ca979276a28ac416c08e9e54c9baee4ae5fd116a35fa13ac", "catalog_fingerprint": "1ae459dc2ba59b6e0a27d5cbeebb27c417dd0be8ddf853fb0c1e533d4e449c9a"}, "sources": [{"url": "https://ftp.postgresql.org/pub/snapshot/dev/postgresql-snapshot.tar.bz2", "label": "Matching PostgreSQL source archive", "sha256": "49c73aa4c9cacef8ca979276a28ac416c08e9e54c9baee4ae5fd116a35fa13ac"}, {"url": "/docs/devel/collation.html#COLLATION-CONCEPTS", "path": "collation.html", "label": "PostgreSQL 20 English manual", "sha256": "075a7361ce39f9db76cc482b29c4b42cf446966ab510aa0017cd6c89b6456c11"}], "zh_from": {"kind": "same-version-chinese-manual-with-source-derived-structured-summary", "manual": {"url": "/zh/docs/devel/collation.html#COLLATION-CONCEPTS", "anchor": "COLLATION-CONCEPTS", "locale": "zh-Hans", "version": "20", "build_id": 111, "page_key": "collation.html", "extraction": "concept-introduction", "source_hash": "10b875cc42ba06313d15957471056455f5d55208c088a34d353d793ea2e709de", "fragment_sha256": "552118fb0e49d5a34aa76120cb7ff1bec4f13114ef47f84e870560eb4af7d124", "source_revision": "sha256:49c73aa4c9cacef8ca979276a28ac416c08e9e54c9baee4ae5fd116a35fa13ac", "translation_revision": "git:b1b500221dbe5437cfca004d6b04d3f6e422765d;html-sha256:98c980963b401d40bd50df72b909e7523e3148b8fdb48edd897de2efb67e5235", "translated_from_revision": "sha256:49c73aa4c9cacef8ca979276a28ac416c08e9e54c9baee4ae5fd116a35fa13ac"}, "body_sha256": "4952568ce25de54e5aa39ff9d1dc16fb57e11c8584458a1ce590c04aa60513c6", "runtime_rerun": false, "authored_translation": "source-derived-structured-summary", "source_facts_revision": "49c73aa4c9cacef8ca979276a28ac416c08e9e54c9baee4ae5fd116a35fa13ac"}, "facts_zh": [{"label": "\u63d0\u4f9b\u8005", "value": "builtin"}, {"label": "\u76ee\u5f55\u4ee3\u7801", "value": "b"}, {"label": "\u8303\u56f4", "value": "\u6e90\u7801\u4e2d\u7684\u63d0\u4f9b\u8005\u6807\u8bc6\uff1b\u5b89\u88c5\u6216\u6784\u5efa\u4e2d\u662f\u5426\u53ef\u7528\u53e6\u884c\u5224\u65ad"}], "sections": [], "center_zh": {"title": "builtin", "locale": "zh-Hans", "source": {"key": "provider-builtin", "locale": "zh-Hans", "version": "20", "text_hash": "b49b6ca508fd4ffb19bb5ecb6525e157b493936287901d852123a0f57eb69bae", "collection": "locale", "dataset_hash": "7c31b524dfe136022d39a6ae8dcfac6b3bbd5f8fdaf422536599981252aff0c9", "source_database": "center", "source_revision": "49c73aa4c9cacef8ca979276a28ac416c08e9e54c9baee4ae5fd116a35fa13ac"}, "payload": {"facts": [{"label": "\u63d0\u4f9b\u8005", "value": "builtin"}, {"label": "\u76ee\u5f55\u4ee3\u7801", "value": "b"}, {"label": "\u8303\u56f4", "value": "\u6e90\u7801\u4e2d\u7684\u63d0\u4f9b\u8005\u6807\u8bc6\uff1b\u5b89\u88c5\u6216\u6784\u5efa\u4e2d\u662f\u5426\u53ef\u7528\u53e6\u884c\u5224\u65ad"}], "tables": [], "zh_from": {"kind": "same-version-chinese-manual-with-source-derived-structured-summary", "manual": {"url": "/zh/docs/devel/collation.html#COLLATION-CONCEPTS", "anchor": "COLLATION-CONCEPTS", "locale": "zh-Hans", "version": "20", "build_id": 111, "page_key": "collation.html", "extraction": "concept-introduction", "source_hash": "10b875cc42ba06313d15957471056455f5d55208c088a34d353d793ea2e709de", "fragment_sha256": "552118fb0e49d5a34aa76120cb7ff1bec4f13114ef47f84e870560eb4af7d124", "source_revision": "sha256:49c73aa4c9cacef8ca979276a28ac416c08e9e54c9baee4ae5fd116a35fa13ac", "translation_revision": "git:b1b500221dbe5437cfca004d6b04d3f6e422765d;html-sha256:98c980963b401d40bd50df72b909e7523e3148b8fdb48edd897de2efb67e5235", "translated_from_revision": "sha256:49c73aa4c9cacef8ca979276a28ac416c08e9e54c9baee4ae5fd116a35fa13ac"}, "body_sha256": "4952568ce25de54e5aa39ff9d1dc16fb57e11c8584458a1ce590c04aa60513c6", "runtime_rerun": false, "authored_translation": "source-derived-structured-summary", "source_facts_revision": "49c73aa4c9cacef8ca979276a28ac416c08e9e54c9baee4ae5fd116a35fa13ac"}, "sections": [], "description_zh": "\u6392\u5e8f\u89c4\u5219\u4e0e\u7f16\u7801 provider-builtin\u3002", "description_zh_html": "<p>\u6392\u5e8f\u89c4\u5219\u4e0e\u7f16\u7801 provider-builtin\u3002</p><dl><dt>\u9002\u7528\u8303\u56f4</dt><dd><code>Source provider identity; installation/build availability is separate</code></dd></dl><h3>\u540c\u7248\u672c\u4e2d\u6587\u624b\u518c\u8282\u9009</h3><p>\n    \u4ece\u6982\u5ff5\u4e0a\u8bb2\uff0c\u6bcf\u4e2a\u652f\u6301\u6392\u5e8f\u89c4\u5219\u7684\u6570\u636e\u7c7b\u578b\u7684\u8868\u8fbe\u5f0f\u90fd\u6709\u4e00\u4e2a\u6392\u5e8f\u89c4\u5219\u3002\uff08\u5185\u7f6e\u7684\u652f\u6301\u6392\u5e8f\u89c4\u5219\u7684\u6570\u636e\u7c7b\u578b\u5305\u62ec <code class=\"type\">text</code>\u3001<code class=\"type\">varchar</code> \u548c <code class=\"type\">char</code>\u3002\u7528\u6237\u5b9a\u4e49\u7684\u57fa\u7840\u7c7b\u578b\u4e5f\u53ef\u4ee5\u6807\u8bb0\u4e3a\u652f\u6301\u6392\u5e8f\u89c4\u5219\uff0c\u5f53\u7136\uff0c\u5efa\u7acb\u5728\u652f\u6301\u6392\u5e8f\u89c4\u5219\u7684\u6570\u636e\u7c7b\u578b\u4e4b\u4e0a\u7684<a class=\"glossterm\" href=\"/zh/docs/devel/glossary.html#GLOSSARY-DOMAIN\"><em class=\"glossterm\"></em></a><em class=\"glossterm\"><a class=\"glossterm\" href=\"/zh/docs/devel/glossary.html#GLOSSARY-DOMAIN\">\u57df</a></em>\u4e5f\u652f\u6301\u6392\u5e8f\u89c4\u5219\u3002\uff09\u5982\u679c\u8868\u8fbe\u5f0f\u662f\u5217\u5f15\u7528\uff0c\u5219\u8be5\u8868\u8fbe\u5f0f\u7684\u6392\u5e8f\u89c4\u5219\u5c31\u662f\u8be5\u5217\u5b9a\u4e49\u7684\u6392\u5e8f\u89c4\u5219\u3002\u5982\u679c\u8868\u8fbe\u5f0f\u662f\u5e38\u91cf\uff0c\u5219\u5176\u6392\u5e8f\u89c4\u5219\u5c31\u662f\u8be5\u5e38\u91cf\u6570\u636e\u7c7b\u578b\u7684\u9ed8\u8ba4\u6392\u5e8f\u89c4\u5219\u3002\u66f4\u590d\u6742\u8868\u8fbe\u5f0f\u7684\u6392\u5e8f\u89c4\u5219\u5219\u6309\u4e0b\u6587\u6240\u8ff0\uff0c\u4ece\u5176\u8f93\u5165\u8868\u8fbe\u5f0f\u7684\u6392\u5e8f\u89c4\u5219\u63a8\u5bfc\u51fa\u6765\u3002\n   </p><p>\n    \u8868\u8fbe\u5f0f\u7684\u6392\u5e8f\u89c4\u5219\u53ef\u4ee5\u662f<span class=\"quote\">\u201c<span class=\"quote\">\u9ed8\u8ba4</span>\u201d</span>\u6392\u5e8f\u89c4\u5219\uff0c\u8fd9\u8868\u793a\u4e3a\u6570\u636e\u5e93\u5b9a\u4e49\u7684\u533a\u57df\u8bbe\u7f6e\u3002\u8868\u8fbe\u5f0f\u7684\u6392\u5e8f\u89c4\u5219\u4e5f\u53ef\u80fd\u662f\u4e0d\u786e\u5b9a\u7684\u3002\u5728\u8fd9\u79cd\u60c5\u51b5\u4e0b\uff0c\u6392\u5e8f\u64cd\u4f5c\u4ee5\u53ca\u5176\u4ed6\u9700\u8981\u77e5\u9053\u6392\u5e8f\u89c4\u5219\u7684\u64cd\u4f5c\u90fd\u4f1a\u5931\u8d25\u3002\n   </p><p>\n    \u5f53\u6570\u636e\u5e93\u7cfb\u7edf\u5fc5\u987b\u6267\u884c\u6392\u5e8f\u6216\u5b57\u7b26\u5206\u7c7b\u65f6\uff0c\u5b83\u4f1a\u4f7f\u7528\u8f93\u5165\u8868\u8fbe\u5f0f\u7684\u6392\u5e8f\u89c4\u5219\u3002\u4f8b\u5982\uff0c\u8fd9\u4f1a\u53d1\u751f\u5728 <code class=\"literal\">ORDER BY</code> \u5b50\u53e5\u4ee5\u53ca\u51fd\u6570\u6216\u64cd\u4f5c\u7b26\u8c03\u7528\uff08\u5982\n    <code class=\"literal\">&lt;</code>\uff09\u4e2d\u3002\u5e94\u7528\u4e8e <code class=\"literal\">ORDER BY</code> \u5b50\u53e5\u7684\u6392\u5e8f\u89c4\u5219\u5c31\u662f\u6392\u5e8f\u952e\u7684\u6392\u5e8f\u89c4\u5219\u3002\u5e94\u7528\u4e8e\u51fd\u6570\u6216\u64cd\u4f5c\u7b26\u8c03\u7528\u7684\u6392\u5e8f\u89c4\u5219\u5219\u6309\u4e0b\u6587\u6240\u8ff0\uff0c\u4ece\u53c2\u6570\u4e2d\u63a8\u5bfc\u51fa\u6765\u3002\u9664\u4e86\u6bd4\u8f83\u64cd\u4f5c\u7b26\u4e4b\u5916\uff0c\u5728\u5927\u5c0f\u5199\u4e4b\u95f4\u8fdb\u884c\u8f6c\u6362\u7684\u51fd\u6570\uff08\u4f8b\u5982 <code class=\"function\">lower</code>\u3001<code class=\"function\">upper</code> \u548c\n    <code class=\"function\">initcap</code>\uff09\u3001\u6a21\u5f0f\u5339\u914d\u64cd\u4f5c\u7b26\uff0c\u4ee5\u53ca <code class=\"function\">to_char</code>\n    \u53ca\u76f8\u5173\u51fd\u6570\uff0c\u4e5f\u90fd\u4f1a\u8003\u8651\u6392\u5e8f\u89c4\u5219\u3002\n   </p><p>\n    \u5bf9\u4e8e\u51fd\u6570\u6216\u64cd\u4f5c\u7b26\u8c03\u7528\uff0c\u901a\u8fc7\u68c0\u67e5\u53c2\u6570\u6392\u5e8f\u89c4\u5219\u63a8\u5bfc\u51fa\u7684\u6392\u5e8f\u89c4\u5219\uff0c\u4f1a\u5728\u8fd0\u884c\u65f6\u7528\u4e8e\u6267\u884c\u6307\u5b9a\u64cd\u4f5c\u3002\u5982\u679c\u8be5\u51fd\u6570\u6216\u64cd\u4f5c\u7b26\u8c03\u7528\u7684\u7ed3\u679c\u5c5e\u4e8e\u652f\u6301\u6392\u5e8f\u89c4\u5219\u7684\u6570\u636e\u7c7b\u578b\uff0c\u90a3\u4e48\u5728\u89e3\u6790\u65f6\u5b83\u4e5f\u4f1a\u88ab\u7528\u4f5c\u8be5\u51fd\u6570\u6216\u64cd\u4f5c\u7b26\u8868\u8fbe\u5f0f\u7684\u5df2\u5b9a\u4e49\u6392\u5e8f\u89c4\u5219\uff0c\u4ee5\u4fbf\u5728\u5916\u56f4\u8868\u8fbe\u5f0f\u9700\u8981\u77e5\u9053\u5176\u6392\u5e8f\u89c4\u5219\u65f6\u4f7f\u7528\u3002\n   </p><p><a href=\"/zh/docs/devel/collation.html#COLLATION-CONCEPTS\">\u67e5\u770b\u5b8c\u6574\u4e2d\u6587\u624b\u518c\u4e0e\u4e0a\u4e0b\u6587</a>\u3002</p>"}, "summary": "\u6392\u5e8f\u89c4\u5219\u4e0e\u7f16\u7801 provider-builtin\u3002", "version": "20", "link_map": {"/zh/docs/devel/glossary.html#GLOSSARY-DOMAIN": "/docs/devel/glossary.html#GLOSSARY-DOMAIN", "/zh/docs/devel/collation.html#COLLATION-CONCEPTS": "/docs/devel/collation.html#COLLATION-CONCEPTS"}, "body_html": "<p>\u6392\u5e8f\u89c4\u5219\u4e0e\u7f16\u7801 provider-builtin\u3002</p><dl><dt>\u9002\u7528\u8303\u56f4</dt><dd><code>Source provider identity; installation/build availability is separate</code></dd></dl><h3>\u540c\u7248\u672c\u4e2d\u6587\u624b\u518c\u8282\u9009</h3><p>\n    \u4ece\u6982\u5ff5\u4e0a\u8bb2\uff0c\u6bcf\u4e2a\u652f\u6301\u6392\u5e8f\u89c4\u5219\u7684\u6570\u636e\u7c7b\u578b\u7684\u8868\u8fbe\u5f0f\u90fd\u6709\u4e00\u4e2a\u6392\u5e8f\u89c4\u5219\u3002\uff08\u5185\u7f6e\u7684\u652f\u6301\u6392\u5e8f\u89c4\u5219\u7684\u6570\u636e\u7c7b\u578b\u5305\u62ec <code>text</code>\u3001<code>varchar</code> \u548c <code>char</code>\u3002\u7528\u6237\u5b9a\u4e49\u7684\u57fa\u7840\u7c7b\u578b\u4e5f\u53ef\u4ee5\u6807\u8bb0\u4e3a\u652f\u6301\u6392\u5e8f\u89c4\u5219\uff0c\u5f53\u7136\uff0c\u5efa\u7acb\u5728\u652f\u6301\u6392\u5e8f\u89c4\u5219\u7684\u6570\u636e\u7c7b\u578b\u4e4b\u4e0a\u7684<a href=\"/zh/docs/devel/glossary.html#GLOSSARY-DOMAIN\" rel=\"nofollow\"><em></em></a><em><a href=\"/zh/docs/devel/glossary.html#GLOSSARY-DOMAIN\" rel=\"nofollow\">\u57df</a></em>\u4e5f\u652f\u6301\u6392\u5e8f\u89c4\u5219\u3002\uff09\u5982\u679c\u8868\u8fbe\u5f0f\u662f\u5217\u5f15\u7528\uff0c\u5219\u8be5\u8868\u8fbe\u5f0f\u7684\u6392\u5e8f\u89c4\u5219\u5c31\u662f\u8be5\u5217\u5b9a\u4e49\u7684\u6392\u5e8f\u89c4\u5219\u3002\u5982\u679c\u8868\u8fbe\u5f0f\u662f\u5e38\u91cf\uff0c\u5219\u5176\u6392\u5e8f\u89c4\u5219\u5c31\u662f\u8be5\u5e38\u91cf\u6570\u636e\u7c7b\u578b\u7684\u9ed8\u8ba4\u6392\u5e8f\u89c4\u5219\u3002\u66f4\u590d\u6742\u8868\u8fbe\u5f0f\u7684\u6392\u5e8f\u89c4\u5219\u5219\u6309\u4e0b\u6587\u6240\u8ff0\uff0c\u4ece\u5176\u8f93\u5165\u8868\u8fbe\u5f0f\u7684\u6392\u5e8f\u89c4\u5219\u63a8\u5bfc\u51fa\u6765\u3002\n   </p><p>\n    \u8868\u8fbe\u5f0f\u7684\u6392\u5e8f\u89c4\u5219\u53ef\u4ee5\u662f<span>\u201c<span>\u9ed8\u8ba4</span>\u201d</span>\u6392\u5e8f\u89c4\u5219\uff0c\u8fd9\u8868\u793a\u4e3a\u6570\u636e\u5e93\u5b9a\u4e49\u7684\u533a\u57df\u8bbe\u7f6e\u3002\u8868\u8fbe\u5f0f\u7684\u6392\u5e8f\u89c4\u5219\u4e5f\u53ef\u80fd\u662f\u4e0d\u786e\u5b9a\u7684\u3002\u5728\u8fd9\u79cd\u60c5\u51b5\u4e0b\uff0c\u6392\u5e8f\u64cd\u4f5c\u4ee5\u53ca\u5176\u4ed6\u9700\u8981\u77e5\u9053\u6392\u5e8f\u89c4\u5219\u7684\u64cd\u4f5c\u90fd\u4f1a\u5931\u8d25\u3002\n   </p><p>\n    \u5f53\u6570\u636e\u5e93\u7cfb\u7edf\u5fc5\u987b\u6267\u884c\u6392\u5e8f\u6216\u5b57\u7b26\u5206\u7c7b\u65f6\uff0c\u5b83\u4f1a\u4f7f\u7528\u8f93\u5165\u8868\u8fbe\u5f0f\u7684\u6392\u5e8f\u89c4\u5219\u3002\u4f8b\u5982\uff0c\u8fd9\u4f1a\u53d1\u751f\u5728 <code>ORDER BY</code> \u5b50\u53e5\u4ee5\u53ca\u51fd\u6570\u6216\u64cd\u4f5c\u7b26\u8c03\u7528\uff08\u5982\n    <code>&lt;</code>\uff09\u4e2d\u3002\u5e94\u7528\u4e8e <code>ORDER BY</code> \u5b50\u53e5\u7684\u6392\u5e8f\u89c4\u5219\u5c31\u662f\u6392\u5e8f\u952e\u7684\u6392\u5e8f\u89c4\u5219\u3002\u5e94\u7528\u4e8e\u51fd\u6570\u6216\u64cd\u4f5c\u7b26\u8c03\u7528\u7684\u6392\u5e8f\u89c4\u5219\u5219\u6309\u4e0b\u6587\u6240\u8ff0\uff0c\u4ece\u53c2\u6570\u4e2d\u63a8\u5bfc\u51fa\u6765\u3002\u9664\u4e86\u6bd4\u8f83\u64cd\u4f5c\u7b26\u4e4b\u5916\uff0c\u5728\u5927\u5c0f\u5199\u4e4b\u95f4\u8fdb\u884c\u8f6c\u6362\u7684\u51fd\u6570\uff08\u4f8b\u5982 <code>lower</code>\u3001<code>upper</code> \u548c\n    <code>initcap</code>\uff09\u3001\u6a21\u5f0f\u5339\u914d\u64cd\u4f5c\u7b26\uff0c\u4ee5\u53ca <code>to_char</code>\n    \u53ca\u76f8\u5173\u51fd\u6570\uff0c\u4e5f\u90fd\u4f1a\u8003\u8651\u6392\u5e8f\u89c4\u5219\u3002\n   </p><p>\n    \u5bf9\u4e8e\u51fd\u6570\u6216\u64cd\u4f5c\u7b26\u8c03\u7528\uff0c\u901a\u8fc7\u68c0\u67e5\u53c2\u6570\u6392\u5e8f\u89c4\u5219\u63a8\u5bfc\u51fa\u7684\u6392\u5e8f\u89c4\u5219\uff0c\u4f1a\u5728\u8fd0\u884c\u65f6\u7528\u4e8e\u6267\u884c\u6307\u5b9a\u64cd\u4f5c\u3002\u5982\u679c\u8be5\u51fd\u6570\u6216\u64cd\u4f5c\u7b26\u8c03\u7528\u7684\u7ed3\u679c\u5c5e\u4e8e\u652f\u6301\u6392\u5e8f\u89c4\u5219\u7684\u6570\u636e\u7c7b\u578b\uff0c\u90a3\u4e48\u5728\u89e3\u6790\u65f6\u5b83\u4e5f\u4f1a\u88ab\u7528\u4f5c\u8be5\u51fd\u6570\u6216\u64cd\u4f5c\u7b26\u8868\u8fbe\u5f0f\u7684\u5df2\u5b9a\u4e49\u6392\u5e8f\u89c4\u5219\uff0c\u4ee5\u4fbf\u5728\u5916\u56f4\u8868\u8fbe\u5f0f\u9700\u8981\u77e5\u9053\u5176\u6392\u5e8f\u89c4\u5219\u65f6\u4f7f\u7528\u3002\n   </p><p><a href=\"/zh/docs/devel/collation.html#COLLATION-CONCEPTS\" rel=\"nofollow\">\u67e5\u770b\u5b8c\u6574\u4e2d\u6587\u624b\u518c\u4e0e\u4e0a\u4e0b\u6587</a>\u3002</p>", "body_sha256": "950f7f6fa5545a1901331f46e9d1596e1b06fd60d3fa068639a7bcc86b2dff0d", "content_hash": "b49b6ca508fd4ffb19bb5ecb6525e157b493936287901d852123a0f57eb69bae", "source_database": "center", "source_revision": "49c73aa4c9cacef8ca979276a28ac416c08e9e54c9baee4ae5fd116a35fa13ac"}, "signature": "", "tables_zh": [], "attributes": {"scope": "Source provider identity; installation/build availability is separate", "provider": "builtin", "catalog_code": "b"}, "description": ["\u6392\u5e8f\u89c4\u5219\u4e0e\u7f16\u7801 provider-builtin\u3002"], "manual_html": "", "manual_path": "/docs/devel/collation.html#COLLATION-CONCEPTS", "sections_zh": [], "localization": {"status": "complete", "sources": [{"url": "/docs/devel/collation.html", "method": "same-major semantic node", "sha256": "55649394e879869166c4d26a543faff79a871cab35978fb0ff4635557151714a", "language": "zh", "matched_nodes": ["#COLLATION/div[1]/dl[0]/dt[0]", "#COLLATION/div[4]/div[6]/ol[0]/li[0]", "#COLLATION/div[4]/div[6]/ol[0]/li[1]", "#COLLATION/div[4]/div[6]/ol[0]/li[2]", "#COLLATION/div[4]/p[11]", "#COLLATION/div[4]/p[13]", "#COLLATION/div[4]/p[15]", "#COLLATION/div[4]/p[17]", "#COLLATION/div[4]/p[19]", "#COLLATION/div[4]/p[1]", "#COLLATION/div[4]/p[21]", "#COLLATION/div[4]/p[22]", "#COLLATION/div[4]/p[24]", "#COLLATION/div[4]/p[26]", "#COLLATION/div[4]/p[2]", "#COLLATION/div[4]/p[3]", "#COLLATION/div[4]/p[4]", "#COLLATION/div[4]/p[5]", "#COLLATION/div[4]/p[7]", "#COLLATION/div[4]/p[9]"]}], "language": "zh", "original_text": {"/summary": "builtin collation provider.", "/category": "Collation provider identities", "/versions/20/description/0": "builtin collation provider.", "/versions/20/facts/0/label": "Provider", "/versions/20/facts/1/label": "Catalog code", "/versions/20/facts/2/label": "Scope", "/versions/20/facts/2/value": "Source provider identity; installation/build availability is separate"}, "fallback_fields": [], "source_language": "en", "original_snapshot_sha256": "54c523495384289e6c42479b95323b6fd51a0413e74c2c5721d457a47ce6b8a5", "canonical_center_text_hash": "b49b6ca508fd4ffb19bb5ecb6525e157b493936287901d852123a0f57eb69bae"}, "description_zh": "\u6392\u5e8f\u89c4\u5219\u4e0e\u7f16\u7801 provider-builtin\u3002", "comparison_data": {"scope": "Source provider identity; installation/build availability is separate", "provider": "builtin", "catalog_code": "b"}, "comparison_hash": "d0ee87b3545cc68aafaa491d16e6d3a73ddc2ded39dd20ba234b922cd06fd397", "manual_language": "zh", "description_zh_html": "<p>\u6392\u5e8f\u89c4\u5219\u4e0e\u7f16\u7801 provider-builtin\u3002</p><dl><dt>\u9002\u7528\u8303\u56f4</dt><dd><code>Source provider identity; installation/build availability is separate</code></dd></dl><h3>\u540c\u7248\u672c\u4e2d\u6587\u624b\u518c\u8282\u9009</h3><p>\n    \u4ece\u6982\u5ff5\u4e0a\u8bb2\uff0c\u6bcf\u4e2a\u652f\u6301\u6392\u5e8f\u89c4\u5219\u7684\u6570\u636e\u7c7b\u578b\u7684\u8868\u8fbe\u5f0f\u90fd\u6709\u4e00\u4e2a\u6392\u5e8f\u89c4\u5219\u3002\uff08\u5185\u7f6e\u7684\u652f\u6301\u6392\u5e8f\u89c4\u5219\u7684\u6570\u636e\u7c7b\u578b\u5305\u62ec <code>text</code>\u3001<code>varchar</code> \u548c <code>char</code>\u3002\u7528\u6237\u5b9a\u4e49\u7684\u57fa\u7840\u7c7b\u578b\u4e5f\u53ef\u4ee5\u6807\u8bb0\u4e3a\u652f\u6301\u6392\u5e8f\u89c4\u5219\uff0c\u5f53\u7136\uff0c\u5efa\u7acb\u5728\u652f\u6301\u6392\u5e8f\u89c4\u5219\u7684\u6570\u636e\u7c7b\u578b\u4e4b\u4e0a\u7684<a href=\"/zh/docs/devel/glossary.html#GLOSSARY-DOMAIN\" rel=\"nofollow\"><em></em></a><em><a href=\"/zh/docs/devel/glossary.html#GLOSSARY-DOMAIN\" rel=\"nofollow\">\u57df</a></em>\u4e5f\u652f\u6301\u6392\u5e8f\u89c4\u5219\u3002\uff09\u5982\u679c\u8868\u8fbe\u5f0f\u662f\u5217\u5f15\u7528\uff0c\u5219\u8be5\u8868\u8fbe\u5f0f\u7684\u6392\u5e8f\u89c4\u5219\u5c31\u662f\u8be5\u5217\u5b9a\u4e49\u7684\u6392\u5e8f\u89c4\u5219\u3002\u5982\u679c\u8868\u8fbe\u5f0f\u662f\u5e38\u91cf\uff0c\u5219\u5176\u6392\u5e8f\u89c4\u5219\u5c31\u662f\u8be5\u5e38\u91cf\u6570\u636e\u7c7b\u578b\u7684\u9ed8\u8ba4\u6392\u5e8f\u89c4\u5219\u3002\u66f4\u590d\u6742\u8868\u8fbe\u5f0f\u7684\u6392\u5e8f\u89c4\u5219\u5219\u6309\u4e0b\u6587\u6240\u8ff0\uff0c\u4ece\u5176\u8f93\u5165\u8868\u8fbe\u5f0f\u7684\u6392\u5e8f\u89c4\u5219\u63a8\u5bfc\u51fa\u6765\u3002\n   </p><p>\n    \u8868\u8fbe\u5f0f\u7684\u6392\u5e8f\u89c4\u5219\u53ef\u4ee5\u662f<span>\u201c<span>\u9ed8\u8ba4</span>\u201d</span>\u6392\u5e8f\u89c4\u5219\uff0c\u8fd9\u8868\u793a\u4e3a\u6570\u636e\u5e93\u5b9a\u4e49\u7684\u533a\u57df\u8bbe\u7f6e\u3002\u8868\u8fbe\u5f0f\u7684\u6392\u5e8f\u89c4\u5219\u4e5f\u53ef\u80fd\u662f\u4e0d\u786e\u5b9a\u7684\u3002\u5728\u8fd9\u79cd\u60c5\u51b5\u4e0b\uff0c\u6392\u5e8f\u64cd\u4f5c\u4ee5\u53ca\u5176\u4ed6\u9700\u8981\u77e5\u9053\u6392\u5e8f\u89c4\u5219\u7684\u64cd\u4f5c\u90fd\u4f1a\u5931\u8d25\u3002\n   </p><p>\n    \u5f53\u6570\u636e\u5e93\u7cfb\u7edf\u5fc5\u987b\u6267\u884c\u6392\u5e8f\u6216\u5b57\u7b26\u5206\u7c7b\u65f6\uff0c\u5b83\u4f1a\u4f7f\u7528\u8f93\u5165\u8868\u8fbe\u5f0f\u7684\u6392\u5e8f\u89c4\u5219\u3002\u4f8b\u5982\uff0c\u8fd9\u4f1a\u53d1\u751f\u5728 <code>ORDER BY</code> \u5b50\u53e5\u4ee5\u53ca\u51fd\u6570\u6216\u64cd\u4f5c\u7b26\u8c03\u7528\uff08\u5982\n    <code>&lt;</code>\uff09\u4e2d\u3002\u5e94\u7528\u4e8e <code>ORDER BY</code> \u5b50\u53e5\u7684\u6392\u5e8f\u89c4\u5219\u5c31\u662f\u6392\u5e8f\u952e\u7684\u6392\u5e8f\u89c4\u5219\u3002\u5e94\u7528\u4e8e\u51fd\u6570\u6216\u64cd\u4f5c\u7b26\u8c03\u7528\u7684\u6392\u5e8f\u89c4\u5219\u5219\u6309\u4e0b\u6587\u6240\u8ff0\uff0c\u4ece\u53c2\u6570\u4e2d\u63a8\u5bfc\u51fa\u6765\u3002\u9664\u4e86\u6bd4\u8f83\u64cd\u4f5c\u7b26\u4e4b\u5916\uff0c\u5728\u5927\u5c0f\u5199\u4e4b\u95f4\u8fdb\u884c\u8f6c\u6362\u7684\u51fd\u6570\uff08\u4f8b\u5982 <code>lower</code>\u3001<code>upper</code> \u548c\n    <code>initcap</code>\uff09\u3001\u6a21\u5f0f\u5339\u914d\u64cd\u4f5c\u7b26\uff0c\u4ee5\u53ca <code>to_char</code>\n    \u53ca\u76f8\u5173\u51fd\u6570\uff0c\u4e5f\u90fd\u4f1a\u8003\u8651\u6392\u5e8f\u89c4\u5219\u3002\n   </p><p>\n    \u5bf9\u4e8e\u51fd\u6570\u6216\u64cd\u4f5c\u7b26\u8c03\u7528\uff0c\u901a\u8fc7\u68c0\u67e5\u53c2\u6570\u6392\u5e8f\u89c4\u5219\u63a8\u5bfc\u51fa\u7684\u6392\u5e8f\u89c4\u5219\uff0c\u4f1a\u5728\u8fd0\u884c\u65f6\u7528\u4e8e\u6267\u884c\u6307\u5b9a\u64cd\u4f5c\u3002\u5982\u679c\u8be5\u51fd\u6570\u6216\u64cd\u4f5c\u7b26\u8c03\u7528\u7684\u7ed3\u679c\u5c5e\u4e8e\u652f\u6301\u6392\u5e8f\u89c4\u5219\u7684\u6570\u636e\u7c7b\u578b\uff0c\u90a3\u4e48\u5728\u89e3\u6790\u65f6\u5b83\u4e5f\u4f1a\u88ab\u7528\u4f5c\u8be5\u51fd\u6570\u6216\u64cd\u4f5c\u7b26\u8868\u8fbe\u5f0f\u7684\u5df2\u5b9a\u4e49\u6392\u5e8f\u89c4\u5219\uff0c\u4ee5\u4fbf\u5728\u5916\u56f4\u8868\u8fbe\u5f0f\u9700\u8981\u77e5\u9053\u5176\u6392\u5e8f\u89c4\u5219\u65f6\u4f7f\u7528\u3002\n   </p><p><a href=\"/zh/docs/devel/collation.html#COLLATION-CONCEPTS\" rel=\"nofollow\">\u67e5\u770b\u5b8c\u6574\u4e2d\u6587\u624b\u518c\u4e0e\u4e0a\u4e0b\u6587</a>\u3002</p>", "source_revalidation": {"kind": "static-same-version-source-and-manual-replay", "audit": "wiki-audit-20261023", "runtime_rerun": false, "compared_fields": "entity membership and source-derived facts; presentation markup normalized", "source_revision": "49c73aa4c9cacef8ca979276a28ac416c08e9e54c9baee4ae5fd116a35fa13ac", "previous_source_revision": "4d3346909b201ac1648232cf290462a7070c119326f56196f1f0253ed80fae41"}}}}, "snapshot": {"facts": [{"label": "\u63d0\u4f9b\u8005", "value": "builtin"}, {"label": "\u76ee\u5f55\u4ee3\u7801", "value": "b"}, {"label": "\u8303\u56f4", "value": "\u6e90\u7801\u4e2d\u7684\u63d0\u4f9b\u8005\u6807\u8bc6\uff1b\u5b89\u88c5\u6216\u6784\u5efa\u4e2d\u662f\u5426\u53ef\u7528\u53e6\u884c\u5224\u65ad"}], "tables": [], "aliases": [], "related": [], "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": "/docs/18/collation.html#COLLATION-CONCEPTS", "path": "collation.html", "label": "PostgreSQL 18 English manual", "sha256": "c98cbca2b2235a896f7fe438a88a99b8d6b9d1f50bdb49fe2794e9982a50797f"}], "zh_from": {"kind": "same-version-chinese-manual-with-source-derived-structured-summary", "manual": {"url": "/zh/docs/18/collation.html#COLLATION-CONCEPTS", "anchor": "COLLATION-CONCEPTS", "locale": "zh-Hans", "version": "18", "build_id": 107, "page_key": "collation.html", "extraction": "concept-introduction", "source_hash": "0bbcf85c650ba958c8d947a7a456ac42ada62afdf57cc030f62d93f756661fac", "fragment_sha256": "a57382d34f6fe21fe2e1d3927479580bbac33099cf1802452a272b78e65aab98", "source_revision": "unknown:rendered-translation-baseline", "translation_revision": "git:b1b500221dbe5437cfca004d6b04d3f6e422765d;html-sha256:08e987a66af27b98444a8057c256314eafa13611a3fb9e888214fc436824244b", "translated_from_revision": null}, "body_sha256": "5ab56ea97e93ce72443a3fa627d29c4a55cb55b0cf3f6d7a7643eda06f6280aa", "runtime_rerun": false, "authored_translation": "source-derived-structured-summary", "source_facts_revision": "555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f"}, "facts_zh": [{"label": "\u63d0\u4f9b\u8005", "value": "builtin"}, {"label": "\u76ee\u5f55\u4ee3\u7801", "value": "b"}, {"label": "\u8303\u56f4", "value": "\u6e90\u7801\u4e2d\u7684\u63d0\u4f9b\u8005\u6807\u8bc6\uff1b\u5b89\u88c5\u6216\u6784\u5efa\u4e2d\u662f\u5426\u53ef\u7528\u53e6\u884c\u5224\u65ad"}], "sections": [], "center_zh": {"title": "builtin", "locale": "zh-Hans", "source": {"key": "provider-builtin", "locale": "zh-Hans", "version": "18", "text_hash": "387483eca2a1d74c471b9c7c24de04e29af1e3459dc81a74718c821ca634b2a1", "collection": "locale", "dataset_hash": "7c31b524dfe136022d39a6ae8dcfac6b3bbd5f8fdaf422536599981252aff0c9", "source_database": "center", "source_revision": "555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f"}, "payload": {"facts": [{"label": "\u63d0\u4f9b\u8005", "value": "builtin"}, {"label": "\u76ee\u5f55\u4ee3\u7801", "value": "b"}, {"label": "\u8303\u56f4", "value": "\u6e90\u7801\u4e2d\u7684\u63d0\u4f9b\u8005\u6807\u8bc6\uff1b\u5b89\u88c5\u6216\u6784\u5efa\u4e2d\u662f\u5426\u53ef\u7528\u53e6\u884c\u5224\u65ad"}], "tables": [], "zh_from": {"kind": "same-version-chinese-manual-with-source-derived-structured-summary", "manual": {"url": "/zh/docs/18/collation.html#COLLATION-CONCEPTS", "anchor": "COLLATION-CONCEPTS", "locale": "zh-Hans", "version": "18", "build_id": 107, "page_key": "collation.html", "extraction": "concept-introduction", "source_hash": "0bbcf85c650ba958c8d947a7a456ac42ada62afdf57cc030f62d93f756661fac", "fragment_sha256": "a57382d34f6fe21fe2e1d3927479580bbac33099cf1802452a272b78e65aab98", "source_revision": "unknown:rendered-translation-baseline", "translation_revision": "git:b1b500221dbe5437cfca004d6b04d3f6e422765d;html-sha256:08e987a66af27b98444a8057c256314eafa13611a3fb9e888214fc436824244b", "translated_from_revision": null}, "body_sha256": "5ab56ea97e93ce72443a3fa627d29c4a55cb55b0cf3f6d7a7643eda06f6280aa", "runtime_rerun": false, "authored_translation": "source-derived-structured-summary", "source_facts_revision": "555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f"}, "sections": [], "description_zh": "\u6392\u5e8f\u89c4\u5219\u4e0e\u7f16\u7801 provider-builtin\u3002", "description_zh_html": "<p>\u6392\u5e8f\u89c4\u5219\u4e0e\u7f16\u7801 provider-builtin\u3002</p><dl><dt>\u9002\u7528\u8303\u56f4</dt><dd><code>Source provider identity; installation/build availability is separate</code></dd></dl><h3>\u540c\u7248\u672c\u4e2d\u6587\u624b\u518c\u8282\u9009</h3><p>\n    \u4ece\u6982\u5ff5\u4e0a\u8bb2\uff0c\u6bcf\u4e2a\u652f\u6301\u6392\u5e8f\u89c4\u5219\u7684\u6570\u636e\u7c7b\u578b\u7684\u8868\u8fbe\u5f0f\u90fd\u6709\u4e00\u4e2a\u6392\u5e8f\u89c4\u5219\u3002\uff08\u5185\u7f6e\u7684\u652f\u6301\u6392\u5e8f\u89c4\u5219\u7684\u6570\u636e\u7c7b\u578b\u5305\u62ec <code class=\"type\">text</code>\u3001<code class=\"type\">varchar</code> \u548c <code class=\"type\">char</code>\u3002\u7528\u6237\u5b9a\u4e49\u7684\u57fa\u7840\u7c7b\u578b\u4e5f\u53ef\u4ee5\u6807\u8bb0\u4e3a\u652f\u6301\u6392\u5e8f\u89c4\u5219\uff0c\u5f53\u7136\uff0c\u5efa\u7acb\u5728\u652f\u6301\u6392\u5e8f\u89c4\u5219\u7684\u6570\u636e\u7c7b\u578b\u4e4b\u4e0a\u7684<a class=\"glossterm\" href=\"/zh/docs/18/glossary.html#GLOSSARY-DOMAIN\"><em class=\"glossterm\"></em></a><em class=\"glossterm\"><a class=\"glossterm\" href=\"/zh/docs/18/glossary.html#GLOSSARY-DOMAIN\">\u57df</a></em>\u4e5f\u652f\u6301\u6392\u5e8f\u89c4\u5219\u3002\uff09\u5982\u679c\u8868\u8fbe\u5f0f\u662f\u5217\u5f15\u7528\uff0c\u5219\u8be5\u8868\u8fbe\u5f0f\u7684\u6392\u5e8f\u89c4\u5219\u5c31\u662f\u8be5\u5217\u5b9a\u4e49\u7684\u6392\u5e8f\u89c4\u5219\u3002\u5982\u679c\u8868\u8fbe\u5f0f\u662f\u5e38\u91cf\uff0c\u5219\u5176\u6392\u5e8f\u89c4\u5219\u5c31\u662f\u8be5\u5e38\u91cf\u6570\u636e\u7c7b\u578b\u7684\u9ed8\u8ba4\u6392\u5e8f\u89c4\u5219\u3002\u66f4\u590d\u6742\u8868\u8fbe\u5f0f\u7684\u6392\u5e8f\u89c4\u5219\u5219\u6309\u4e0b\u6587\u6240\u8ff0\uff0c\u4ece\u5176\u8f93\u5165\u8868\u8fbe\u5f0f\u7684\u6392\u5e8f\u89c4\u5219\u63a8\u5bfc\u51fa\u6765\u3002\n   </p><p>\n    \u8868\u8fbe\u5f0f\u7684\u6392\u5e8f\u89c4\u5219\u53ef\u4ee5\u662f<span class=\"quote\">\u201c<span class=\"quote\">\u9ed8\u8ba4</span>\u201d</span>\u6392\u5e8f\u89c4\u5219\uff0c\u8fd9\u8868\u793a\u4e3a\u6570\u636e\u5e93\u5b9a\u4e49\u7684\u533a\u57df\u8bbe\u7f6e\u3002\u8868\u8fbe\u5f0f\u7684\u6392\u5e8f\u89c4\u5219\u4e5f\u53ef\u80fd\u662f\u4e0d\u786e\u5b9a\u7684\u3002\u5728\u8fd9\u79cd\u60c5\u51b5\u4e0b\uff0c\u6392\u5e8f\u64cd\u4f5c\u4ee5\u53ca\u5176\u4ed6\u9700\u8981\u77e5\u9053\u6392\u5e8f\u89c4\u5219\u7684\u64cd\u4f5c\u90fd\u4f1a\u5931\u8d25\u3002\n   </p><p>\n    \u5f53\u6570\u636e\u5e93\u7cfb\u7edf\u5fc5\u987b\u6267\u884c\u6392\u5e8f\u6216\u5b57\u7b26\u5206\u7c7b\u65f6\uff0c\u5b83\u4f1a\u4f7f\u7528\u8f93\u5165\u8868\u8fbe\u5f0f\u7684\u6392\u5e8f\u89c4\u5219\u3002\u4f8b\u5982\uff0c\u8fd9\u4f1a\u53d1\u751f\u5728 <code class=\"literal\">ORDER BY</code> \u5b50\u53e5\u4ee5\u53ca\u51fd\u6570\u6216\u64cd\u4f5c\u7b26\u8c03\u7528\uff08\u5982\n    <code class=\"literal\">&lt;</code>\uff09\u4e2d\u3002\u5e94\u7528\u4e8e <code class=\"literal\">ORDER BY</code> \u5b50\u53e5\u7684\u6392\u5e8f\u89c4\u5219\u5c31\u662f\u6392\u5e8f\u952e\u7684\u6392\u5e8f\u89c4\u5219\u3002\u5e94\u7528\u4e8e\u51fd\u6570\u6216\u64cd\u4f5c\u7b26\u8c03\u7528\u7684\u6392\u5e8f\u89c4\u5219\u5219\u6309\u4e0b\u6587\u6240\u8ff0\uff0c\u4ece\u53c2\u6570\u4e2d\u63a8\u5bfc\u51fa\u6765\u3002\u9664\u4e86\u6bd4\u8f83\u64cd\u4f5c\u7b26\u4e4b\u5916\uff0c\u5728\u5927\u5c0f\u5199\u4e4b\u95f4\u8fdb\u884c\u8f6c\u6362\u7684\u51fd\u6570\uff08\u4f8b\u5982 <code class=\"function\">lower</code>\u3001<code class=\"function\">upper</code> \u548c\n    <code class=\"function\">initcap</code>\uff09\u3001\u6a21\u5f0f\u5339\u914d\u64cd\u4f5c\u7b26\uff0c\u4ee5\u53ca <code class=\"function\">to_char</code>\n    \u53ca\u76f8\u5173\u51fd\u6570\uff0c\u4e5f\u90fd\u4f1a\u8003\u8651\u6392\u5e8f\u89c4\u5219\u3002\n   </p><p>\n    \u5bf9\u4e8e\u51fd\u6570\u6216\u64cd\u4f5c\u7b26\u8c03\u7528\uff0c\u901a\u8fc7\u68c0\u67e5\u53c2\u6570\u6392\u5e8f\u89c4\u5219\u63a8\u5bfc\u51fa\u7684\u6392\u5e8f\u89c4\u5219\uff0c\u4f1a\u5728\u8fd0\u884c\u65f6\u7528\u4e8e\u6267\u884c\u6307\u5b9a\u64cd\u4f5c\u3002\u5982\u679c\u8be5\u51fd\u6570\u6216\u64cd\u4f5c\u7b26\u8c03\u7528\u7684\u7ed3\u679c\u5c5e\u4e8e\u652f\u6301\u6392\u5e8f\u89c4\u5219\u7684\u6570\u636e\u7c7b\u578b\uff0c\u90a3\u4e48\u5728\u89e3\u6790\u65f6\u5b83\u4e5f\u4f1a\u88ab\u7528\u4f5c\u8be5\u51fd\u6570\u6216\u64cd\u4f5c\u7b26\u8868\u8fbe\u5f0f\u7684\u5df2\u5b9a\u4e49\u6392\u5e8f\u89c4\u5219\uff0c\u4ee5\u4fbf\u5728\u5916\u56f4\u8868\u8fbe\u5f0f\u9700\u8981\u77e5\u9053\u5176\u6392\u5e8f\u89c4\u5219\u65f6\u4f7f\u7528\u3002\n   </p><p><a href=\"/zh/docs/18/collation.html#COLLATION-CONCEPTS\">\u67e5\u770b\u5b8c\u6574\u4e2d\u6587\u624b\u518c\u4e0e\u4e0a\u4e0b\u6587</a>\u3002</p>"}, "summary": "\u6392\u5e8f\u89c4\u5219\u4e0e\u7f16\u7801 provider-builtin\u3002", "version": "18", "link_map": {"/zh/docs/18/glossary.html#GLOSSARY-DOMAIN": "/docs/18/glossary.html#GLOSSARY-DOMAIN", "/zh/docs/18/collation.html#COLLATION-CONCEPTS": "/docs/18/collation.html#COLLATION-CONCEPTS"}, "body_html": "<p>\u6392\u5e8f\u89c4\u5219\u4e0e\u7f16\u7801 provider-builtin\u3002</p><dl><dt>\u9002\u7528\u8303\u56f4</dt><dd><code>Source provider identity; installation/build availability is separate</code></dd></dl><h3>\u540c\u7248\u672c\u4e2d\u6587\u624b\u518c\u8282\u9009</h3><p>\n    \u4ece\u6982\u5ff5\u4e0a\u8bb2\uff0c\u6bcf\u4e2a\u652f\u6301\u6392\u5e8f\u89c4\u5219\u7684\u6570\u636e\u7c7b\u578b\u7684\u8868\u8fbe\u5f0f\u90fd\u6709\u4e00\u4e2a\u6392\u5e8f\u89c4\u5219\u3002\uff08\u5185\u7f6e\u7684\u652f\u6301\u6392\u5e8f\u89c4\u5219\u7684\u6570\u636e\u7c7b\u578b\u5305\u62ec <code>text</code>\u3001<code>varchar</code> \u548c <code>char</code>\u3002\u7528\u6237\u5b9a\u4e49\u7684\u57fa\u7840\u7c7b\u578b\u4e5f\u53ef\u4ee5\u6807\u8bb0\u4e3a\u652f\u6301\u6392\u5e8f\u89c4\u5219\uff0c\u5f53\u7136\uff0c\u5efa\u7acb\u5728\u652f\u6301\u6392\u5e8f\u89c4\u5219\u7684\u6570\u636e\u7c7b\u578b\u4e4b\u4e0a\u7684<a href=\"/zh/docs/18/glossary.html#GLOSSARY-DOMAIN\" rel=\"nofollow\"><em></em></a><em><a href=\"/zh/docs/18/glossary.html#GLOSSARY-DOMAIN\" rel=\"nofollow\">\u57df</a></em>\u4e5f\u652f\u6301\u6392\u5e8f\u89c4\u5219\u3002\uff09\u5982\u679c\u8868\u8fbe\u5f0f\u662f\u5217\u5f15\u7528\uff0c\u5219\u8be5\u8868\u8fbe\u5f0f\u7684\u6392\u5e8f\u89c4\u5219\u5c31\u662f\u8be5\u5217\u5b9a\u4e49\u7684\u6392\u5e8f\u89c4\u5219\u3002\u5982\u679c\u8868\u8fbe\u5f0f\u662f\u5e38\u91cf\uff0c\u5219\u5176\u6392\u5e8f\u89c4\u5219\u5c31\u662f\u8be5\u5e38\u91cf\u6570\u636e\u7c7b\u578b\u7684\u9ed8\u8ba4\u6392\u5e8f\u89c4\u5219\u3002\u66f4\u590d\u6742\u8868\u8fbe\u5f0f\u7684\u6392\u5e8f\u89c4\u5219\u5219\u6309\u4e0b\u6587\u6240\u8ff0\uff0c\u4ece\u5176\u8f93\u5165\u8868\u8fbe\u5f0f\u7684\u6392\u5e8f\u89c4\u5219\u63a8\u5bfc\u51fa\u6765\u3002\n   </p><p>\n    \u8868\u8fbe\u5f0f\u7684\u6392\u5e8f\u89c4\u5219\u53ef\u4ee5\u662f<span>\u201c<span>\u9ed8\u8ba4</span>\u201d</span>\u6392\u5e8f\u89c4\u5219\uff0c\u8fd9\u8868\u793a\u4e3a\u6570\u636e\u5e93\u5b9a\u4e49\u7684\u533a\u57df\u8bbe\u7f6e\u3002\u8868\u8fbe\u5f0f\u7684\u6392\u5e8f\u89c4\u5219\u4e5f\u53ef\u80fd\u662f\u4e0d\u786e\u5b9a\u7684\u3002\u5728\u8fd9\u79cd\u60c5\u51b5\u4e0b\uff0c\u6392\u5e8f\u64cd\u4f5c\u4ee5\u53ca\u5176\u4ed6\u9700\u8981\u77e5\u9053\u6392\u5e8f\u89c4\u5219\u7684\u64cd\u4f5c\u90fd\u4f1a\u5931\u8d25\u3002\n   </p><p>\n    \u5f53\u6570\u636e\u5e93\u7cfb\u7edf\u5fc5\u987b\u6267\u884c\u6392\u5e8f\u6216\u5b57\u7b26\u5206\u7c7b\u65f6\uff0c\u5b83\u4f1a\u4f7f\u7528\u8f93\u5165\u8868\u8fbe\u5f0f\u7684\u6392\u5e8f\u89c4\u5219\u3002\u4f8b\u5982\uff0c\u8fd9\u4f1a\u53d1\u751f\u5728 <code>ORDER BY</code> \u5b50\u53e5\u4ee5\u53ca\u51fd\u6570\u6216\u64cd\u4f5c\u7b26\u8c03\u7528\uff08\u5982\n    <code>&lt;</code>\uff09\u4e2d\u3002\u5e94\u7528\u4e8e <code>ORDER BY</code> \u5b50\u53e5\u7684\u6392\u5e8f\u89c4\u5219\u5c31\u662f\u6392\u5e8f\u952e\u7684\u6392\u5e8f\u89c4\u5219\u3002\u5e94\u7528\u4e8e\u51fd\u6570\u6216\u64cd\u4f5c\u7b26\u8c03\u7528\u7684\u6392\u5e8f\u89c4\u5219\u5219\u6309\u4e0b\u6587\u6240\u8ff0\uff0c\u4ece\u53c2\u6570\u4e2d\u63a8\u5bfc\u51fa\u6765\u3002\u9664\u4e86\u6bd4\u8f83\u64cd\u4f5c\u7b26\u4e4b\u5916\uff0c\u5728\u5927\u5c0f\u5199\u4e4b\u95f4\u8fdb\u884c\u8f6c\u6362\u7684\u51fd\u6570\uff08\u4f8b\u5982 <code>lower</code>\u3001<code>upper</code> \u548c\n    <code>initcap</code>\uff09\u3001\u6a21\u5f0f\u5339\u914d\u64cd\u4f5c\u7b26\uff0c\u4ee5\u53ca <code>to_char</code>\n    \u53ca\u76f8\u5173\u51fd\u6570\uff0c\u4e5f\u90fd\u4f1a\u8003\u8651\u6392\u5e8f\u89c4\u5219\u3002\n   </p><p>\n    \u5bf9\u4e8e\u51fd\u6570\u6216\u64cd\u4f5c\u7b26\u8c03\u7528\uff0c\u901a\u8fc7\u68c0\u67e5\u53c2\u6570\u6392\u5e8f\u89c4\u5219\u63a8\u5bfc\u51fa\u7684\u6392\u5e8f\u89c4\u5219\uff0c\u4f1a\u5728\u8fd0\u884c\u65f6\u7528\u4e8e\u6267\u884c\u6307\u5b9a\u64cd\u4f5c\u3002\u5982\u679c\u8be5\u51fd\u6570\u6216\u64cd\u4f5c\u7b26\u8c03\u7528\u7684\u7ed3\u679c\u5c5e\u4e8e\u652f\u6301\u6392\u5e8f\u89c4\u5219\u7684\u6570\u636e\u7c7b\u578b\uff0c\u90a3\u4e48\u5728\u89e3\u6790\u65f6\u5b83\u4e5f\u4f1a\u88ab\u7528\u4f5c\u8be5\u51fd\u6570\u6216\u64cd\u4f5c\u7b26\u8868\u8fbe\u5f0f\u7684\u5df2\u5b9a\u4e49\u6392\u5e8f\u89c4\u5219\uff0c\u4ee5\u4fbf\u5728\u5916\u56f4\u8868\u8fbe\u5f0f\u9700\u8981\u77e5\u9053\u5176\u6392\u5e8f\u89c4\u5219\u65f6\u4f7f\u7528\u3002\n   </p><p><a href=\"/zh/docs/18/collation.html#COLLATION-CONCEPTS\" rel=\"nofollow\">\u67e5\u770b\u5b8c\u6574\u4e2d\u6587\u624b\u518c\u4e0e\u4e0a\u4e0b\u6587</a>\u3002</p>", "body_sha256": "ee0f6c082cd6ce71d65f820ffe057383cacff664d0672dc65d6c33f646f8b0c1", "content_hash": "387483eca2a1d74c471b9c7c24de04e29af1e3459dc81a74718c821ca634b2a1", "source_database": "center", "source_revision": "555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f"}, "signature": "", "tables_zh": [], "attributes": {"scope": "Source provider identity; installation/build availability is separate", "provider": "builtin", "catalog_code": "b"}, "description": ["\u6392\u5e8f\u89c4\u5219\u4e0e\u7f16\u7801 provider-builtin\u3002"], "manual_html": "", "manual_path": "/docs/18/collation.html#COLLATION-CONCEPTS", "sections_zh": [], "localization": {"status": "complete", "sources": [{"url": "/docs/18/collation.html", "method": "same-major semantic node", "sha256": "4fa99946c7c01ec3872b49a1fa92cadcd30d5a34d425829f836674d5c63b571a", "language": "zh", "matched_nodes": ["#COLLATION/div[1]/dl[0]/dt[0]", "#COLLATION/div[4]/div[6]/ol[0]/li[0]", "#COLLATION/div[4]/div[6]/ol[0]/li[1]", "#COLLATION/div[4]/div[6]/ol[0]/li[2]", "#COLLATION/div[4]/p[11]", "#COLLATION/div[4]/p[13]", "#COLLATION/div[4]/p[15]", "#COLLATION/div[4]/p[17]", "#COLLATION/div[4]/p[19]", "#COLLATION/div[4]/p[1]", "#COLLATION/div[4]/p[21]", "#COLLATION/div[4]/p[22]", "#COLLATION/div[4]/p[24]", "#COLLATION/div[4]/p[26]", "#COLLATION/div[4]/p[2]", "#COLLATION/div[4]/p[3]", "#COLLATION/div[4]/p[4]", "#COLLATION/div[4]/p[5]", "#COLLATION/div[4]/p[7]", "#COLLATION/div[4]/p[9]"]}], "language": "zh", "original_text": {"/versions/18/description/0": "builtin collation provider.", "/versions/18/facts/0/label": "Provider", "/versions/18/facts/1/label": "Catalog code", "/versions/18/facts/2/label": "Scope", "/versions/18/facts/2/value": "Source provider identity; installation/build availability is separate"}, "fallback_fields": [], "source_language": "en", "original_snapshot_sha256": "f54ac7d1c33504a93ebfb570406cdab96f733288e878d9095544e490da7c7bf1", "canonical_center_text_hash": "387483eca2a1d74c471b9c7c24de04e29af1e3459dc81a74718c821ca634b2a1"}, "description_zh": "\u6392\u5e8f\u89c4\u5219\u4e0e\u7f16\u7801 provider-builtin\u3002", "comparison_data": {"scope": "Source provider identity; installation/build availability is separate", "provider": "builtin", "catalog_code": "b"}, "comparison_hash": "d0ee87b3545cc68aafaa491d16e6d3a73ddc2ded39dd20ba234b922cd06fd397", "manual_language": "zh", "description_zh_html": "<p>\u6392\u5e8f\u89c4\u5219\u4e0e\u7f16\u7801 provider-builtin\u3002</p><dl><dt>\u9002\u7528\u8303\u56f4</dt><dd><code>Source provider identity; installation/build availability is separate</code></dd></dl><h3>\u540c\u7248\u672c\u4e2d\u6587\u624b\u518c\u8282\u9009</h3><p>\n    \u4ece\u6982\u5ff5\u4e0a\u8bb2\uff0c\u6bcf\u4e2a\u652f\u6301\u6392\u5e8f\u89c4\u5219\u7684\u6570\u636e\u7c7b\u578b\u7684\u8868\u8fbe\u5f0f\u90fd\u6709\u4e00\u4e2a\u6392\u5e8f\u89c4\u5219\u3002\uff08\u5185\u7f6e\u7684\u652f\u6301\u6392\u5e8f\u89c4\u5219\u7684\u6570\u636e\u7c7b\u578b\u5305\u62ec <code>text</code>\u3001<code>varchar</code> \u548c <code>char</code>\u3002\u7528\u6237\u5b9a\u4e49\u7684\u57fa\u7840\u7c7b\u578b\u4e5f\u53ef\u4ee5\u6807\u8bb0\u4e3a\u652f\u6301\u6392\u5e8f\u89c4\u5219\uff0c\u5f53\u7136\uff0c\u5efa\u7acb\u5728\u652f\u6301\u6392\u5e8f\u89c4\u5219\u7684\u6570\u636e\u7c7b\u578b\u4e4b\u4e0a\u7684<a href=\"/zh/docs/18/glossary.html#GLOSSARY-DOMAIN\" rel=\"nofollow\"><em></em></a><em><a href=\"/zh/docs/18/glossary.html#GLOSSARY-DOMAIN\" rel=\"nofollow\">\u57df</a></em>\u4e5f\u652f\u6301\u6392\u5e8f\u89c4\u5219\u3002\uff09\u5982\u679c\u8868\u8fbe\u5f0f\u662f\u5217\u5f15\u7528\uff0c\u5219\u8be5\u8868\u8fbe\u5f0f\u7684\u6392\u5e8f\u89c4\u5219\u5c31\u662f\u8be5\u5217\u5b9a\u4e49\u7684\u6392\u5e8f\u89c4\u5219\u3002\u5982\u679c\u8868\u8fbe\u5f0f\u662f\u5e38\u91cf\uff0c\u5219\u5176\u6392\u5e8f\u89c4\u5219\u5c31\u662f\u8be5\u5e38\u91cf\u6570\u636e\u7c7b\u578b\u7684\u9ed8\u8ba4\u6392\u5e8f\u89c4\u5219\u3002\u66f4\u590d\u6742\u8868\u8fbe\u5f0f\u7684\u6392\u5e8f\u89c4\u5219\u5219\u6309\u4e0b\u6587\u6240\u8ff0\uff0c\u4ece\u5176\u8f93\u5165\u8868\u8fbe\u5f0f\u7684\u6392\u5e8f\u89c4\u5219\u63a8\u5bfc\u51fa\u6765\u3002\n   </p><p>\n    \u8868\u8fbe\u5f0f\u7684\u6392\u5e8f\u89c4\u5219\u53ef\u4ee5\u662f<span>\u201c<span>\u9ed8\u8ba4</span>\u201d</span>\u6392\u5e8f\u89c4\u5219\uff0c\u8fd9\u8868\u793a\u4e3a\u6570\u636e\u5e93\u5b9a\u4e49\u7684\u533a\u57df\u8bbe\u7f6e\u3002\u8868\u8fbe\u5f0f\u7684\u6392\u5e8f\u89c4\u5219\u4e5f\u53ef\u80fd\u662f\u4e0d\u786e\u5b9a\u7684\u3002\u5728\u8fd9\u79cd\u60c5\u51b5\u4e0b\uff0c\u6392\u5e8f\u64cd\u4f5c\u4ee5\u53ca\u5176\u4ed6\u9700\u8981\u77e5\u9053\u6392\u5e8f\u89c4\u5219\u7684\u64cd\u4f5c\u90fd\u4f1a\u5931\u8d25\u3002\n   </p><p>\n    \u5f53\u6570\u636e\u5e93\u7cfb\u7edf\u5fc5\u987b\u6267\u884c\u6392\u5e8f\u6216\u5b57\u7b26\u5206\u7c7b\u65f6\uff0c\u5b83\u4f1a\u4f7f\u7528\u8f93\u5165\u8868\u8fbe\u5f0f\u7684\u6392\u5e8f\u89c4\u5219\u3002\u4f8b\u5982\uff0c\u8fd9\u4f1a\u53d1\u751f\u5728 <code>ORDER BY</code> \u5b50\u53e5\u4ee5\u53ca\u51fd\u6570\u6216\u64cd\u4f5c\u7b26\u8c03\u7528\uff08\u5982\n    <code>&lt;</code>\uff09\u4e2d\u3002\u5e94\u7528\u4e8e <code>ORDER BY</code> \u5b50\u53e5\u7684\u6392\u5e8f\u89c4\u5219\u5c31\u662f\u6392\u5e8f\u952e\u7684\u6392\u5e8f\u89c4\u5219\u3002\u5e94\u7528\u4e8e\u51fd\u6570\u6216\u64cd\u4f5c\u7b26\u8c03\u7528\u7684\u6392\u5e8f\u89c4\u5219\u5219\u6309\u4e0b\u6587\u6240\u8ff0\uff0c\u4ece\u53c2\u6570\u4e2d\u63a8\u5bfc\u51fa\u6765\u3002\u9664\u4e86\u6bd4\u8f83\u64cd\u4f5c\u7b26\u4e4b\u5916\uff0c\u5728\u5927\u5c0f\u5199\u4e4b\u95f4\u8fdb\u884c\u8f6c\u6362\u7684\u51fd\u6570\uff08\u4f8b\u5982 <code>lower</code>\u3001<code>upper</code> \u548c\n    <code>initcap</code>\uff09\u3001\u6a21\u5f0f\u5339\u914d\u64cd\u4f5c\u7b26\uff0c\u4ee5\u53ca <code>to_char</code>\n    \u53ca\u76f8\u5173\u51fd\u6570\uff0c\u4e5f\u90fd\u4f1a\u8003\u8651\u6392\u5e8f\u89c4\u5219\u3002\n   </p><p>\n    \u5bf9\u4e8e\u51fd\u6570\u6216\u64cd\u4f5c\u7b26\u8c03\u7528\uff0c\u901a\u8fc7\u68c0\u67e5\u53c2\u6570\u6392\u5e8f\u89c4\u5219\u63a8\u5bfc\u51fa\u7684\u6392\u5e8f\u89c4\u5219\uff0c\u4f1a\u5728\u8fd0\u884c\u65f6\u7528\u4e8e\u6267\u884c\u6307\u5b9a\u64cd\u4f5c\u3002\u5982\u679c\u8be5\u51fd\u6570\u6216\u64cd\u4f5c\u7b26\u8c03\u7528\u7684\u7ed3\u679c\u5c5e\u4e8e\u652f\u6301\u6392\u5e8f\u89c4\u5219\u7684\u6570\u636e\u7c7b\u578b\uff0c\u90a3\u4e48\u5728\u89e3\u6790\u65f6\u5b83\u4e5f\u4f1a\u88ab\u7528\u4f5c\u8be5\u51fd\u6570\u6216\u64cd\u4f5c\u7b26\u8868\u8fbe\u5f0f\u7684\u5df2\u5b9a\u4e49\u6392\u5e8f\u89c4\u5219\uff0c\u4ee5\u4fbf\u5728\u5916\u56f4\u8868\u8fbe\u5f0f\u9700\u8981\u77e5\u9053\u5176\u6392\u5e8f\u89c4\u5219\u65f6\u4f7f\u7528\u3002\n   </p><p><a href=\"/zh/docs/18/collation.html#COLLATION-CONCEPTS\" rel=\"nofollow\">\u67e5\u770b\u5b8c\u6574\u4e2d\u6587\u624b\u518c\u4e0e\u4e0a\u4e0b\u6587</a>\u3002</p>", "center_zh_rendered": "<p>\u6392\u5e8f\u89c4\u5219\u4e0e\u7f16\u7801 provider-builtin\u3002</p><dl><dt>\u9002\u7528\u8303\u56f4</dt><dd><code>Source provider identity; installation/build availability is separate</code></dd></dl><h3>\u540c\u7248\u672c\u4e2d\u6587\u624b\u518c\u8282\u9009</h3><p>\n    \u4ece\u6982\u5ff5\u4e0a\u8bb2\uff0c\u6bcf\u4e2a\u652f\u6301\u6392\u5e8f\u89c4\u5219\u7684\u6570\u636e\u7c7b\u578b\u7684\u8868\u8fbe\u5f0f\u90fd\u6709\u4e00\u4e2a\u6392\u5e8f\u89c4\u5219\u3002\uff08\u5185\u7f6e\u7684\u652f\u6301\u6392\u5e8f\u89c4\u5219\u7684\u6570\u636e\u7c7b\u578b\u5305\u62ec <code>text</code>\u3001<code>varchar</code> \u548c <code>char</code>\u3002\u7528\u6237\u5b9a\u4e49\u7684\u57fa\u7840\u7c7b\u578b\u4e5f\u53ef\u4ee5\u6807\u8bb0\u4e3a\u652f\u6301\u6392\u5e8f\u89c4\u5219\uff0c\u5f53\u7136\uff0c\u5efa\u7acb\u5728\u652f\u6301\u6392\u5e8f\u89c4\u5219\u7684\u6570\u636e\u7c7b\u578b\u4e4b\u4e0a\u7684<a href=\"/docs/18/glossary.html#GLOSSARY-DOMAIN\"><em></em></a><em><a href=\"/docs/18/glossary.html#GLOSSARY-DOMAIN\">\u57df</a></em>\u4e5f\u652f\u6301\u6392\u5e8f\u89c4\u5219\u3002\uff09\u5982\u679c\u8868\u8fbe\u5f0f\u662f\u5217\u5f15\u7528\uff0c\u5219\u8be5\u8868\u8fbe\u5f0f\u7684\u6392\u5e8f\u89c4\u5219\u5c31\u662f\u8be5\u5217\u5b9a\u4e49\u7684\u6392\u5e8f\u89c4\u5219\u3002\u5982\u679c\u8868\u8fbe\u5f0f\u662f\u5e38\u91cf\uff0c\u5219\u5176\u6392\u5e8f\u89c4\u5219\u5c31\u662f\u8be5\u5e38\u91cf\u6570\u636e\u7c7b\u578b\u7684\u9ed8\u8ba4\u6392\u5e8f\u89c4\u5219\u3002\u66f4\u590d\u6742\u8868\u8fbe\u5f0f\u7684\u6392\u5e8f\u89c4\u5219\u5219\u6309\u4e0b\u6587\u6240\u8ff0\uff0c\u4ece\u5176\u8f93\u5165\u8868\u8fbe\u5f0f\u7684\u6392\u5e8f\u89c4\u5219\u63a8\u5bfc\u51fa\u6765\u3002\n   </p><p>\n    \u8868\u8fbe\u5f0f\u7684\u6392\u5e8f\u89c4\u5219\u53ef\u4ee5\u662f<span>\u201c<span>\u9ed8\u8ba4</span>\u201d</span>\u6392\u5e8f\u89c4\u5219\uff0c\u8fd9\u8868\u793a\u4e3a\u6570\u636e\u5e93\u5b9a\u4e49\u7684\u533a\u57df\u8bbe\u7f6e\u3002\u8868\u8fbe\u5f0f\u7684\u6392\u5e8f\u89c4\u5219\u4e5f\u53ef\u80fd\u662f\u4e0d\u786e\u5b9a\u7684\u3002\u5728\u8fd9\u79cd\u60c5\u51b5\u4e0b\uff0c\u6392\u5e8f\u64cd\u4f5c\u4ee5\u53ca\u5176\u4ed6\u9700\u8981\u77e5\u9053\u6392\u5e8f\u89c4\u5219\u7684\u64cd\u4f5c\u90fd\u4f1a\u5931\u8d25\u3002\n   </p><p>\n    \u5f53\u6570\u636e\u5e93\u7cfb\u7edf\u5fc5\u987b\u6267\u884c\u6392\u5e8f\u6216\u5b57\u7b26\u5206\u7c7b\u65f6\uff0c\u5b83\u4f1a\u4f7f\u7528\u8f93\u5165\u8868\u8fbe\u5f0f\u7684\u6392\u5e8f\u89c4\u5219\u3002\u4f8b\u5982\uff0c\u8fd9\u4f1a\u53d1\u751f\u5728 <code>ORDER BY</code> \u5b50\u53e5\u4ee5\u53ca\u51fd\u6570\u6216\u64cd\u4f5c\u7b26\u8c03\u7528\uff08\u5982\n    <code>&lt;</code>\uff09\u4e2d\u3002\u5e94\u7528\u4e8e <code>ORDER BY</code> \u5b50\u53e5\u7684\u6392\u5e8f\u89c4\u5219\u5c31\u662f\u6392\u5e8f\u952e\u7684\u6392\u5e8f\u89c4\u5219\u3002\u5e94\u7528\u4e8e\u51fd\u6570\u6216\u64cd\u4f5c\u7b26\u8c03\u7528\u7684\u6392\u5e8f\u89c4\u5219\u5219\u6309\u4e0b\u6587\u6240\u8ff0\uff0c\u4ece\u53c2\u6570\u4e2d\u63a8\u5bfc\u51fa\u6765\u3002\u9664\u4e86\u6bd4\u8f83\u64cd\u4f5c\u7b26\u4e4b\u5916\uff0c\u5728\u5927\u5c0f\u5199\u4e4b\u95f4\u8fdb\u884c\u8f6c\u6362\u7684\u51fd\u6570\uff08\u4f8b\u5982 <code>lower</code>\u3001<code>upper</code> \u548c\n    <code>initcap</code>\uff09\u3001\u6a21\u5f0f\u5339\u914d\u64cd\u4f5c\u7b26\uff0c\u4ee5\u53ca <code>to_char</code>\n    \u53ca\u76f8\u5173\u51fd\u6570\uff0c\u4e5f\u90fd\u4f1a\u8003\u8651\u6392\u5e8f\u89c4\u5219\u3002\n   </p><p>\n    \u5bf9\u4e8e\u51fd\u6570\u6216\u64cd\u4f5c\u7b26\u8c03\u7528\uff0c\u901a\u8fc7\u68c0\u67e5\u53c2\u6570\u6392\u5e8f\u89c4\u5219\u63a8\u5bfc\u51fa\u7684\u6392\u5e8f\u89c4\u5219\uff0c\u4f1a\u5728\u8fd0\u884c\u65f6\u7528\u4e8e\u6267\u884c\u6307\u5b9a\u64cd\u4f5c\u3002\u5982\u679c\u8be5\u51fd\u6570\u6216\u64cd\u4f5c\u7b26\u8c03\u7528\u7684\u7ed3\u679c\u5c5e\u4e8e\u652f\u6301\u6392\u5e8f\u89c4\u5219\u7684\u6570\u636e\u7c7b\u578b\uff0c\u90a3\u4e48\u5728\u89e3\u6790\u65f6\u5b83\u4e5f\u4f1a\u88ab\u7528\u4f5c\u8be5\u51fd\u6570\u6216\u64cd\u4f5c\u7b26\u8868\u8fbe\u5f0f\u7684\u5df2\u5b9a\u4e49\u6392\u5e8f\u89c4\u5219\uff0c\u4ee5\u4fbf\u5728\u5916\u56f4\u8868\u8fbe\u5f0f\u9700\u8981\u77e5\u9053\u5176\u6392\u5e8f\u89c4\u5219\u65f6\u4f7f\u7528\u3002\n   </p><p><a href=\"/docs/18/collation.html#COLLATION-CONCEPTS\">\u67e5\u770b\u5b8c\u6574\u4e2d\u6587\u624b\u518c\u4e0e\u4e0a\u4e0b\u6587</a>\u3002</p>"}, "comparison": {"left": "17", "right": "18", "status": "unchanged", "diff": ""}}