{"kind": "locale", "major": "18", "item": {"slug": "provider-builtin", "name": "builtin", "name_zh": "", "category": "\u6392\u5e8f\u89c4\u5219\u63d0\u4f9b\u8005\u6807\u8bc6", "summary": "builtin \u6392\u5e8f\u89c4\u5219\u63d0\u4f9b\u8005\u3002", "aliases": [], "content_hash": "2af41d61dedeb83bd10f206bf722595c48b4f3ecf0dde8b91c5168c718b328e3", "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": "https://pg.center/docs/17/collation.html#COLLATION-CONCEPTS", "path": "collation.html", "label": "PostgreSQL 17 English manual", "sha256": "67aac7b4c281b861af98f8f644ba2c3381358ffed48a74134fc269d0ae968029", "language": "en", "original_url": "/docs/17/collation.html#COLLATION-CONCEPTS"}], "sections": [], "signature": "", "attributes": {"scope": "Source provider identity; installation/build availability is separate", "provider": "builtin", "catalog_code": "b"}, "description": ["builtin \u6392\u5e8f\u89c4\u5219\u63d0\u4f9b\u8005\u3002"], "manual_html": "<div class=\"sect2\" id=\"COLLATION-CONCEPTS\">\n<div class=\"titlepage\">\n<div>\n<div>\n<h3 class=\"title\" lang=\"zh\"><span class=\"sect2\"><a href=\"/docs/17/collation.html#COLLATION-CONCEPTS\">23.2.1. \u6982\u5ff5</a></span></h3>\n</div>\n</div>\n</div>\n<p lang=\"zh\">\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=\"/docs/17/glossary.html#GLOSSARY-DOMAIN\"></a><a class=\"glossterm\" href=\"/docs/17/glossary.html#GLOSSARY-DOMAIN\" title=\"\u57df\">\u57df</a>\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</p>\n<p lang=\"zh\">\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</p>\n<p lang=\"zh\">\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 <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 <code class=\"function\">initcap</code>\uff09\u3001\u6a21\u5f0f\u5339\u914d\u64cd\u4f5c\u7b26\uff0c\u4ee5\u53ca<code class=\"function\">to_char</code> \u53ca\u76f8\u5173\u51fd\u6570\uff0c\u4e5f\u90fd\u4f1a\u8003\u8651\u6392\u5e8f\u89c4\u5219\u3002</p>\n<p lang=\"zh\">\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</p>\n<p lang=\"zh\">\u8868\u8fbe\u5f0f\u7684<em class=\"firstterm\">\u6392\u5e8f\u89c4\u5219\u6d3e\u751f</em>\u53ef\u4ee5\u662f\u663e\u5f0f\u7684\uff0c\u4e5f\u53ef\u4ee5\u662f\u9690\u5f0f\u7684\u3002\u8fd9\u4e00\u533a\u522b\u4f1a\u5f71\u54cd\u5f53\u4e00\u4e2a\u8868\u8fbe\u5f0f\u4e2d\u51fa\u73b0\u591a\u4e2a\u4e0d\u540c\u6392\u5e8f\u89c4\u5219\u65f6\uff0c\u7cfb\u7edf\u5982\u4f55\u628a\u5b83\u4eec\u7ec4\u5408\u8d77\u6765\u3002\u4f7f\u7528<code class=\"literal\">COLLATE</code>\u5b50\u53e5\u65f6\uff0c\u4f1a\u53d1\u751f\u663e\u5f0f\u6392\u5e8f\u89c4\u5219\u6d3e\u751f\uff1b\u5176\u4ed6\u6240\u6709\u6392\u5e8f\u89c4\u5219\u6d3e\u751f\u90fd\u662f\u9690\u5f0f\u7684\u3002\u5f53\u9700\u8981\u7ec4\u5408\u591a\u4e2a\u6392\u5e8f\u89c4\u5219\u65f6\uff0c\u4f8b\u5982\u5728\u51fd\u6570\u8c03\u7528\u4e2d\uff0c\u5c06\u4f7f\u7528\u4ee5\u4e0b\u89c4\u5219\uff1a</p>\n<div class=\"orderedlist\">\n<ol class=\"orderedlist\">\n<li class=\"listitem\" lang=\"zh\">\n<p>\u5982\u679c\u4efb\u4e00\u8f93\u5165\u8868\u8fbe\u5f0f\u5177\u6709\u663e\u5f0f\u6392\u5e8f\u89c4\u5219\u6d3e\u751f\uff0c\u90a3\u4e48\u8f93\u5165\u8868\u8fbe\u5f0f\u4e2d\u6240\u6709\u663e\u5f0f\u6d3e\u751f\u7684\u6392\u5e8f\u89c4\u5219\u90fd\u5fc5\u987b\u76f8\u540c\uff0c\u5426\u5219\u4f1a\u62a5\u9519\u3002\u5982\u679c\u5b58\u5728\u663e\u5f0f\u6d3e\u751f\u7684\u6392\u5e8f\u89c4\u5219\uff0c\u90a3\u4e48\u6392\u5e8f\u89c4\u5219\u7ec4\u5408\u7684\u7ed3\u679c\u5c31\u662f\u8be5\u6392\u5e8f\u89c4\u5219\u3002</p>\n</li>\n<li class=\"listitem\" lang=\"zh\">\n<p>\u5426\u5219\uff0c\u6240\u6709\u8f93\u5165\u8868\u8fbe\u5f0f\u90fd\u5fc5\u987b\u5177\u6709\u76f8\u540c\u7684\u9690\u5f0f\u6392\u5e8f\u89c4\u5219\u6d3e\u751f\uff0c\u6216\u8005\u4e3a\u9ed8\u8ba4\u6392\u5e8f\u89c4\u5219\u3002\u5982\u679c\u5b58\u5728\u4efb\u4f55\u975e\u9ed8\u8ba4\u6392\u5e8f\u89c4\u5219\uff0c\u90a3\u4e48\u6392\u5e8f\u89c4\u5219\u7ec4\u5408\u7684\u7ed3\u679c\u5c31\u662f\u8be5\u6392\u5e8f\u89c4\u5219\uff1b\u5426\u5219\uff0c\u7ed3\u679c\u5c31\u662f\u9ed8\u8ba4\u6392\u5e8f\u89c4\u5219\u3002</p>\n</li>\n<li class=\"listitem\" lang=\"zh\">\n<p>\u5982\u679c\u8f93\u5165\u8868\u8fbe\u5f0f\u4e4b\u95f4\u5b58\u5728\u76f8\u4e92\u51b2\u7a81\u7684\u975e\u9ed8\u8ba4\u9690\u5f0f\u6392\u5e8f\u89c4\u5219\uff0c\u5219\u8be5\u7ec4\u5408\u4f1a\u88ab\u89c6\u4e3a\u5177\u6709\u4e0d\u786e\u5b9a\u6392\u5e8f\u89c4\u5219\u3002\u9664\u975e\u88ab\u8c03\u7528\u7684\u7279\u5b9a\u51fd\u6570\u786e\u5b9e\u9700\u8981\u77e5\u9053\u5b83\u5e94\u5f53\u4f7f\u7528\u54ea\u4e2a\u6392\u5e8f\u89c4\u5219\uff0c\u5426\u5219\u8fd9\u5e76\u4e0d\u662f\u9519\u8bef\u3002\u5982\u679c\u5b83\u786e\u5b9e\u9700\u8981\uff0c\u5c31\u4f1a\u5728\u8fd0\u884c\u65f6\u629b\u51fa\u9519\u8bef\u3002</p>\n</li>\n</ol>\n</div>\n<p lang=\"zh\">\u4f8b\u5982\uff0c\u8003\u8651\u5982\u4e0b\u8868\u5b9a\u4e49\uff1a</p>\n<pre class=\"programlisting\">CREATE TABLE test1 (\n    a text COLLATE \"de_DE\",\n    b text COLLATE \"es_ES\",\n    ...\n);\n</pre>\n<p lang=\"zh\">\u90a3\u4e48\u5728</p>\n<pre class=\"programlisting\">SELECT a &lt; 'foo' FROM test1;\n</pre>\n<p lang=\"zh\">\u4e2d\uff0c<code class=\"literal\">&lt;</code>\u6bd4\u8f83\u4f1a\u6309<code class=\"literal\">de_DE</code>\u89c4\u5219\u8fdb\u884c\uff0c\u56e0\u4e3a\u8be5\u8868\u8fbe\u5f0f\u7ec4\u5408\u4e86\u4e00\u4e2a\u9690\u5f0f\u6d3e\u751f\u7684\u6392\u5e8f\u89c4\u5219\u548c\u9ed8\u8ba4\u6392\u5e8f\u89c4\u5219\u3002\u4f46\u5728</p>\n<pre class=\"programlisting\">SELECT a &lt; ('foo' COLLATE \"fr_FR\") FROM test1;\n</pre>\n<p lang=\"zh\">\u4e2d\uff0c\u6bd4\u8f83\u4f1a\u6309<code class=\"literal\">fr_FR</code>\u89c4\u5219\u8fdb\u884c\uff0c\u56e0\u4e3a\u663e\u5f0f\u6392\u5e8f\u89c4\u5219\u6d3e\u751f\u8986\u76d6\u4e86\u9690\u5f0f\u6d3e\u751f\u3002\u8fdb\u4e00\u6b65\uff0c\u7ed9\u5b9a</p>\n<pre class=\"programlisting\">SELECT a &lt; b FROM test1;\n</pre>\n<p lang=\"zh\">\u89e3\u6790\u5668\u65e0\u6cd5\u786e\u5b9a\u5e94\u5f53\u5e94\u7528\u54ea\u4e2a\u6392\u5e8f\u89c4\u5219\uff0c\u56e0\u4e3a<code class=\"structfield\">a</code>\u5217\u548c<code class=\"structfield\">b</code>\u5217\u5177\u6709\u51b2\u7a81\u7684\u9690\u5f0f\u6392\u5e8f\u89c4\u5219\u3002\u7531\u4e8e <code class=\"literal\">&lt;</code>\u64cd\u4f5c\u7b26\u786e\u5b9e\u9700\u8981\u77e5\u9053\u8981\u4f7f\u7528\u54ea\u4e2a\u6392\u5e8f\u89c4\u5219\uff0c\u56e0\u6b64\u8fd9\u4f1a\u5bfc\u81f4\u4e00\u4e2a\u9519\u8bef\u3002\u8be5\u9519\u8bef\u53ef\u4ee5\u901a\u8fc7\u7ed9\u4efb\u4e00\u8f93\u5165\u8868\u8fbe\u5f0f\u9644\u52a0\u663e\u5f0f\u6392\u5e8f\u89c4\u5219\u8bf4\u660e\u7b26\u6765\u89e3\u51b3\uff0c\u4f8b\u5982\uff1a</p>\n<pre class=\"programlisting\">SELECT a &lt; b COLLATE \"de_DE\" FROM test1;\n</pre>\n<p lang=\"zh\">\u6216\u8005\u7b49\u4ef7\u5730\uff1a</p>\n<pre class=\"programlisting\">SELECT a COLLATE \"de_DE\" &lt; b FROM test1;\n</pre>\n<p lang=\"zh\">\u53e6\u4e00\u65b9\u9762\uff0c\u7ed3\u6784\u76f8\u4f3c\u7684\u60c5\u51b5</p>\n<pre class=\"programlisting\">SELECT a || b FROM test1;\n</pre>\n<p lang=\"zh\">\u4e0d\u4f1a\u5bfc\u81f4\u9519\u8bef\uff0c\u56e0\u4e3a<code class=\"literal\">||</code>\u64cd\u4f5c\u7b26\u4e0d\u5173\u5fc3\u6392\u5e8f\u89c4\u5219\uff1a\u65e0\u8bba\u4f7f\u7528\u4ec0\u4e48\u6392\u5e8f\u89c4\u5219\uff0c\u5176\u7ed3\u679c\u90fd\u76f8\u540c\u3002</p>\n<p lang=\"zh\">\u5982\u679c\u51fd\u6570\u6216\u64cd\u4f5c\u7b26\u8fd4\u56de\u7684\u662f\u652f\u6301\u6392\u5e8f\u89c4\u5219\u7684\u6570\u636e\u7c7b\u578b\uff0c\u90a3\u4e48\u5206\u914d\u7ed9\u8be5\u51fd\u6570\u6216\u64cd\u4f5c\u7b26\u7684\u8f93\u5165\u8868\u8fbe\u5f0f\u7ec4\u5408\u7684\u6392\u5e8f\u89c4\u5219\uff0c\u4e5f\u88ab\u8ba4\u4e3a\u9002\u7528\u4e8e\u5176\u7ed3\u679c\u3002\u56e0\u6b64\uff0c\u5728</p>\n<pre class=\"programlisting\">SELECT * FROM test1 ORDER BY a || 'foo';\n</pre>\n<p lang=\"zh\">\u4e2d\uff0c\u6392\u5e8f\u5c06\u6309<code class=\"literal\">de_DE</code>\u89c4\u5219\u8fdb\u884c\u3002\u4f46\u8fd9\u4e2a\u67e5\u8be2\uff1a</p>\n<pre class=\"programlisting\">SELECT * FROM test1 ORDER BY a || b;\n</pre>\n<p lang=\"zh\">\u4f1a\u62a5\u9519\uff0c\u56e0\u4e3a\u5373\u4f7f<code class=\"literal\">||</code>\u64cd\u4f5c\u7b26\u672c\u8eab\u4e0d\u9700\u8981\u77e5\u9053\u6392\u5e8f\u89c4\u5219\uff0c<code class=\"literal\">ORDER BY</code>\u5b50\u53e5\u4ecd\u7136\u9700\u8981\u3002\u4e0e\u4e4b\u524d\u4e00\u6837\uff0c\u53ef\u4ee5\u901a\u8fc7\u663e\u5f0f\u6392\u5e8f\u89c4\u5219\u8bf4\u660e\u7b26\u6765\u89e3\u51b3\u51b2\u7a81\uff1a</p>\n<pre class=\"programlisting\">SELECT * FROM test1 ORDER BY a || b COLLATE \"fr_FR\";\n</pre>\n</div>", "manual_path": "/docs/17/collation.html#COLLATION-CONCEPTS", "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"}, "comparison_data": {"scope": "Source provider identity; installation/build availability is separate", "provider": "builtin", "catalog_code": "b"}, "comparison_hash": "d0ee87b3545cc68aafaa491d16e6d3a73ddc2ded39dd20ba234b922cd06fd397", "manual_language": "zh"}, "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": "https://pg.center/docs/18/collation.html#COLLATION-CONCEPTS", "path": "collation.html", "label": "PostgreSQL 18 English manual", "sha256": "c98cbca2b2235a896f7fe438a88a99b8d6b9d1f50bdb49fe2794e9982a50797f", "language": "en", "original_url": "/docs/18/collation.html#COLLATION-CONCEPTS"}], "sections": [], "signature": "", "attributes": {"scope": "Source provider identity; installation/build availability is separate", "provider": "builtin", "catalog_code": "b"}, "description": ["builtin \u6392\u5e8f\u89c4\u5219\u63d0\u4f9b\u8005\u3002"], "manual_html": "<div class=\"sect2\" id=\"COLLATION-CONCEPTS\">\n<div class=\"titlepage\">\n<div>\n<div>\n<h3 class=\"title\" lang=\"zh\"><span class=\"sect2\"><a href=\"/docs/18/collation.html#COLLATION-CONCEPTS\">23.2.1. \u6982\u5ff5</a></span></h3>\n</div>\n</div>\n</div>\n<p lang=\"zh\">\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=\"/docs/18/glossary.html#GLOSSARY-DOMAIN\"></a><a class=\"glossterm\" href=\"/docs/18/glossary.html#GLOSSARY-DOMAIN\" title=\"\u57df\">\u57df</a>\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</p>\n<p lang=\"zh\">\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</p>\n<p lang=\"zh\">\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 <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 <code class=\"function\">initcap</code>\uff09\u3001\u6a21\u5f0f\u5339\u914d\u64cd\u4f5c\u7b26\uff0c\u4ee5\u53ca<code class=\"function\">to_char</code> \u53ca\u76f8\u5173\u51fd\u6570\uff0c\u4e5f\u90fd\u4f1a\u8003\u8651\u6392\u5e8f\u89c4\u5219\u3002</p>\n<p lang=\"zh\">\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</p>\n<p lang=\"zh\">\u8868\u8fbe\u5f0f\u7684<em class=\"firstterm\">\u6392\u5e8f\u89c4\u5219\u6d3e\u751f</em>\u53ef\u4ee5\u662f\u663e\u5f0f\u7684\uff0c\u4e5f\u53ef\u4ee5\u662f\u9690\u5f0f\u7684\u3002\u8fd9\u4e00\u533a\u522b\u4f1a\u5f71\u54cd\u5f53\u4e00\u4e2a\u8868\u8fbe\u5f0f\u4e2d\u51fa\u73b0\u591a\u4e2a\u4e0d\u540c\u6392\u5e8f\u89c4\u5219\u65f6\uff0c\u7cfb\u7edf\u5982\u4f55\u628a\u5b83\u4eec\u7ec4\u5408\u8d77\u6765\u3002\u4f7f\u7528<code class=\"literal\">COLLATE</code>\u5b50\u53e5\u65f6\uff0c\u4f1a\u53d1\u751f\u663e\u5f0f\u6392\u5e8f\u89c4\u5219\u6d3e\u751f\uff1b\u5176\u4ed6\u6240\u6709\u6392\u5e8f\u89c4\u5219\u6d3e\u751f\u90fd\u662f\u9690\u5f0f\u7684\u3002\u5f53\u9700\u8981\u7ec4\u5408\u591a\u4e2a\u6392\u5e8f\u89c4\u5219\u65f6\uff0c\u4f8b\u5982\u5728\u51fd\u6570\u8c03\u7528\u4e2d\uff0c\u5c06\u4f7f\u7528\u4ee5\u4e0b\u89c4\u5219\uff1a</p>\n<div class=\"orderedlist\">\n<ol class=\"orderedlist\">\n<li class=\"listitem\" lang=\"zh\">\n<p>\u5982\u679c\u4efb\u4e00\u8f93\u5165\u8868\u8fbe\u5f0f\u5177\u6709\u663e\u5f0f\u6392\u5e8f\u89c4\u5219\u6d3e\u751f\uff0c\u90a3\u4e48\u8f93\u5165\u8868\u8fbe\u5f0f\u4e2d\u6240\u6709\u663e\u5f0f\u6d3e\u751f\u7684\u6392\u5e8f\u89c4\u5219\u90fd\u5fc5\u987b\u76f8\u540c\uff0c\u5426\u5219\u4f1a\u62a5\u9519\u3002\u5982\u679c\u5b58\u5728\u663e\u5f0f\u6d3e\u751f\u7684\u6392\u5e8f\u89c4\u5219\uff0c\u90a3\u4e48\u6392\u5e8f\u89c4\u5219\u7ec4\u5408\u7684\u7ed3\u679c\u5c31\u662f\u8be5\u6392\u5e8f\u89c4\u5219\u3002</p>\n</li>\n<li class=\"listitem\" lang=\"zh\">\n<p>\u5426\u5219\uff0c\u6240\u6709\u8f93\u5165\u8868\u8fbe\u5f0f\u90fd\u5fc5\u987b\u5177\u6709\u76f8\u540c\u7684\u9690\u5f0f\u6392\u5e8f\u89c4\u5219\u6d3e\u751f\uff0c\u6216\u8005\u4e3a\u9ed8\u8ba4\u6392\u5e8f\u89c4\u5219\u3002\u5982\u679c\u5b58\u5728\u4efb\u4f55\u975e\u9ed8\u8ba4\u6392\u5e8f\u89c4\u5219\uff0c\u90a3\u4e48\u6392\u5e8f\u89c4\u5219\u7ec4\u5408\u7684\u7ed3\u679c\u5c31\u662f\u8be5\u6392\u5e8f\u89c4\u5219\uff1b\u5426\u5219\uff0c\u7ed3\u679c\u5c31\u662f\u9ed8\u8ba4\u6392\u5e8f\u89c4\u5219\u3002</p>\n</li>\n<li class=\"listitem\" lang=\"zh\">\n<p>\u5982\u679c\u8f93\u5165\u8868\u8fbe\u5f0f\u4e4b\u95f4\u5b58\u5728\u76f8\u4e92\u51b2\u7a81\u7684\u975e\u9ed8\u8ba4\u9690\u5f0f\u6392\u5e8f\u89c4\u5219\uff0c\u5219\u8be5\u7ec4\u5408\u4f1a\u88ab\u89c6\u4e3a\u5177\u6709\u4e0d\u786e\u5b9a\u6392\u5e8f\u89c4\u5219\u3002\u9664\u975e\u88ab\u8c03\u7528\u7684\u7279\u5b9a\u51fd\u6570\u786e\u5b9e\u9700\u8981\u77e5\u9053\u5b83\u5e94\u5f53\u4f7f\u7528\u54ea\u4e2a\u6392\u5e8f\u89c4\u5219\uff0c\u5426\u5219\u8fd9\u5e76\u4e0d\u662f\u9519\u8bef\u3002\u5982\u679c\u5b83\u786e\u5b9e\u9700\u8981\uff0c\u5c31\u4f1a\u5728\u8fd0\u884c\u65f6\u629b\u51fa\u9519\u8bef\u3002</p>\n</li>\n</ol>\n</div>\n<p lang=\"zh\">\u4f8b\u5982\uff0c\u8003\u8651\u5982\u4e0b\u8868\u5b9a\u4e49\uff1a</p>\n<pre class=\"programlisting\">CREATE TABLE test1 (\n    a text COLLATE \"de_DE\",\n    b text COLLATE \"es_ES\",\n    ...\n);\n</pre>\n<p lang=\"zh\">\u90a3\u4e48\u5728</p>\n<pre class=\"programlisting\">SELECT a &lt; 'foo' FROM test1;\n</pre>\n<p lang=\"zh\">\u4e2d\uff0c<code class=\"literal\">&lt;</code>\u6bd4\u8f83\u4f1a\u6309<code class=\"literal\">de_DE</code>\u89c4\u5219\u8fdb\u884c\uff0c\u56e0\u4e3a\u8be5\u8868\u8fbe\u5f0f\u7ec4\u5408\u4e86\u4e00\u4e2a\u9690\u5f0f\u6d3e\u751f\u7684\u6392\u5e8f\u89c4\u5219\u548c\u9ed8\u8ba4\u6392\u5e8f\u89c4\u5219\u3002\u4f46\u5728</p>\n<pre class=\"programlisting\">SELECT a &lt; ('foo' COLLATE \"fr_FR\") FROM test1;\n</pre>\n<p lang=\"zh\">\u4e2d\uff0c\u6bd4\u8f83\u4f1a\u6309<code class=\"literal\">fr_FR</code>\u89c4\u5219\u8fdb\u884c\uff0c\u56e0\u4e3a\u663e\u5f0f\u6392\u5e8f\u89c4\u5219\u6d3e\u751f\u8986\u76d6\u4e86\u9690\u5f0f\u6d3e\u751f\u3002\u8fdb\u4e00\u6b65\uff0c\u7ed9\u5b9a</p>\n<pre class=\"programlisting\">SELECT a &lt; b FROM test1;\n</pre>\n<p lang=\"zh\">\u89e3\u6790\u5668\u65e0\u6cd5\u786e\u5b9a\u5e94\u5f53\u5e94\u7528\u54ea\u4e2a\u6392\u5e8f\u89c4\u5219\uff0c\u56e0\u4e3a<code class=\"structfield\">a</code>\u5217\u548c<code class=\"structfield\">b</code>\u5217\u5177\u6709\u51b2\u7a81\u7684\u9690\u5f0f\u6392\u5e8f\u89c4\u5219\u3002\u7531\u4e8e <code class=\"literal\">&lt;</code>\u64cd\u4f5c\u7b26\u786e\u5b9e\u9700\u8981\u77e5\u9053\u8981\u4f7f\u7528\u54ea\u4e2a\u6392\u5e8f\u89c4\u5219\uff0c\u56e0\u6b64\u8fd9\u4f1a\u5bfc\u81f4\u4e00\u4e2a\u9519\u8bef\u3002\u8be5\u9519\u8bef\u53ef\u4ee5\u901a\u8fc7\u7ed9\u4efb\u4e00\u8f93\u5165\u8868\u8fbe\u5f0f\u9644\u52a0\u663e\u5f0f\u6392\u5e8f\u89c4\u5219\u8bf4\u660e\u7b26\u6765\u89e3\u51b3\uff0c\u4f8b\u5982\uff1a</p>\n<pre class=\"programlisting\">SELECT a &lt; b COLLATE \"de_DE\" FROM test1;\n</pre>\n<p lang=\"zh\">\u6216\u8005\u7b49\u4ef7\u5730\uff1a</p>\n<pre class=\"programlisting\">SELECT a COLLATE \"de_DE\" &lt; b FROM test1;\n</pre>\n<p lang=\"zh\">\u53e6\u4e00\u65b9\u9762\uff0c\u7ed3\u6784\u76f8\u4f3c\u7684\u60c5\u51b5</p>\n<pre class=\"programlisting\">SELECT a || b FROM test1;\n</pre>\n<p lang=\"zh\">\u4e0d\u4f1a\u5bfc\u81f4\u9519\u8bef\uff0c\u56e0\u4e3a<code class=\"literal\">||</code>\u64cd\u4f5c\u7b26\u4e0d\u5173\u5fc3\u6392\u5e8f\u89c4\u5219\uff1a\u65e0\u8bba\u4f7f\u7528\u4ec0\u4e48\u6392\u5e8f\u89c4\u5219\uff0c\u5176\u7ed3\u679c\u90fd\u76f8\u540c\u3002</p>\n<p lang=\"zh\">\u5982\u679c\u51fd\u6570\u6216\u64cd\u4f5c\u7b26\u8fd4\u56de\u7684\u662f\u652f\u6301\u6392\u5e8f\u89c4\u5219\u7684\u6570\u636e\u7c7b\u578b\uff0c\u90a3\u4e48\u5206\u914d\u7ed9\u8be5\u51fd\u6570\u6216\u64cd\u4f5c\u7b26\u7684\u8f93\u5165\u8868\u8fbe\u5f0f\u7ec4\u5408\u7684\u6392\u5e8f\u89c4\u5219\uff0c\u4e5f\u88ab\u8ba4\u4e3a\u9002\u7528\u4e8e\u5176\u7ed3\u679c\u3002\u56e0\u6b64\uff0c\u5728</p>\n<pre class=\"programlisting\">SELECT * FROM test1 ORDER BY a || 'foo';\n</pre>\n<p lang=\"zh\">\u4e2d\uff0c\u6392\u5e8f\u5c06\u6309<code class=\"literal\">de_DE</code>\u89c4\u5219\u8fdb\u884c\u3002\u4f46\u8fd9\u4e2a\u67e5\u8be2\uff1a</p>\n<pre class=\"programlisting\">SELECT * FROM test1 ORDER BY a || b;\n</pre>\n<p lang=\"zh\">\u4f1a\u62a5\u9519\uff0c\u56e0\u4e3a\u5373\u4f7f<code class=\"literal\">||</code>\u64cd\u4f5c\u7b26\u672c\u8eab\u4e0d\u9700\u8981\u77e5\u9053\u6392\u5e8f\u89c4\u5219\uff0c<code class=\"literal\">ORDER BY</code>\u5b50\u53e5\u4ecd\u7136\u9700\u8981\u3002\u4e0e\u4e4b\u524d\u4e00\u6837\uff0c\u53ef\u4ee5\u901a\u8fc7\u663e\u5f0f\u6392\u5e8f\u89c4\u5219\u8bf4\u660e\u7b26\u6765\u89e3\u51b3\u51b2\u7a81\uff1a</p>\n<pre class=\"programlisting\">SELECT * FROM test1 ORDER BY a || b COLLATE \"fr_FR\";\n</pre>\n</div>", "manual_path": "/docs/18/collation.html#COLLATION-CONCEPTS", "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"}, "comparison_data": {"scope": "Source provider identity; installation/build availability is separate", "provider": "builtin", "catalog_code": "b"}, "comparison_hash": "d0ee87b3545cc68aafaa491d16e6d3a73ddc2ded39dd20ba234b922cd06fd397", "manual_language": "zh"}, "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/v19beta4/postgresql-19beta4.tar.bz2", "label": "19beta4", "major": "19", "channel": "preview", "revision": "83157ee9c599d03b2f7a3d73ef3a56ec24e0e79cc2b3501a64d1364f56398c86", "source_sha256": "83157ee9c599d03b2f7a3d73ef3a56ec24e0e79cc2b3501a64d1364f56398c86", "catalog_fingerprint": "62fbf1a3689dbe8bf7e6b3372cfe6fbf867581427b3858a94c8419b77a4d2d1d"}, "sources": [{"url": "https://ftp.postgresql.org/pub/source/v19beta4/postgresql-19beta4.tar.bz2", "label": "Matching PostgreSQL source archive", "sha256": "83157ee9c599d03b2f7a3d73ef3a56ec24e0e79cc2b3501a64d1364f56398c86"}, {"url": "https://pg.center/docs/19/collation.html#COLLATION-CONCEPTS", "path": "collation.html", "label": "PostgreSQL 19 English manual", "sha256": "2eef5fdde9bbc23617bb28de2a76a46c48b5a51662dc9212b1ceb56a85199a5e", "language": "en", "original_url": "/docs/19/collation.html#COLLATION-CONCEPTS"}], "sections": [], "signature": "", "attributes": {"scope": "Source provider identity; installation/build availability is separate", "provider": "builtin", "catalog_code": "b"}, "description": ["builtin \u6392\u5e8f\u89c4\u5219\u63d0\u4f9b\u8005\u3002"], "manual_html": "<div class=\"sect2\" id=\"COLLATION-CONCEPTS\">\n<div class=\"titlepage\">\n<div>\n<div>\n<h3 class=\"title\" lang=\"zh\"><span class=\"sect2\"><a href=\"/docs/19/collation.html#COLLATION-CONCEPTS\">23.2.1. \u6982\u5ff5</a></span></h3>\n</div>\n</div>\n</div>\n<p lang=\"zh\">\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=\"/docs/19/glossary.html#GLOSSARY-DOMAIN\"></a><a class=\"glossterm\" href=\"/docs/19/glossary.html#GLOSSARY-DOMAIN\" title=\"\u57df\">\u57df</a>\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</p>\n<p lang=\"zh\">\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</p>\n<p lang=\"zh\">\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 <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 <code class=\"function\">initcap</code>\uff09\u3001\u6a21\u5f0f\u5339\u914d\u64cd\u4f5c\u7b26\uff0c\u4ee5\u53ca<code class=\"function\">to_char</code> \u53ca\u76f8\u5173\u51fd\u6570\uff0c\u4e5f\u90fd\u4f1a\u8003\u8651\u6392\u5e8f\u89c4\u5219\u3002</p>\n<p lang=\"zh\">\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</p>\n<p lang=\"zh\">\u8868\u8fbe\u5f0f\u7684<em class=\"firstterm\">\u6392\u5e8f\u89c4\u5219\u6d3e\u751f</em>\u53ef\u4ee5\u662f\u663e\u5f0f\u7684\uff0c\u4e5f\u53ef\u4ee5\u662f\u9690\u5f0f\u7684\u3002\u8fd9\u4e00\u533a\u522b\u4f1a\u5f71\u54cd\u5f53\u4e00\u4e2a\u8868\u8fbe\u5f0f\u4e2d\u51fa\u73b0\u591a\u4e2a\u4e0d\u540c\u6392\u5e8f\u89c4\u5219\u65f6\uff0c\u7cfb\u7edf\u5982\u4f55\u628a\u5b83\u4eec\u7ec4\u5408\u8d77\u6765\u3002\u4f7f\u7528<code class=\"literal\">COLLATE</code>\u5b50\u53e5\u65f6\uff0c\u4f1a\u53d1\u751f\u663e\u5f0f\u6392\u5e8f\u89c4\u5219\u6d3e\u751f\uff1b\u5176\u4ed6\u6240\u6709\u6392\u5e8f\u89c4\u5219\u6d3e\u751f\u90fd\u662f\u9690\u5f0f\u7684\u3002\u5f53\u9700\u8981\u7ec4\u5408\u591a\u4e2a\u6392\u5e8f\u89c4\u5219\u65f6\uff0c\u4f8b\u5982\u5728\u51fd\u6570\u8c03\u7528\u4e2d\uff0c\u5c06\u4f7f\u7528\u4ee5\u4e0b\u89c4\u5219\uff1a</p>\n<div class=\"orderedlist\">\n<ol class=\"orderedlist\">\n<li class=\"listitem\" lang=\"zh\">\n<p>\u5982\u679c\u4efb\u4e00\u8f93\u5165\u8868\u8fbe\u5f0f\u5177\u6709\u663e\u5f0f\u6392\u5e8f\u89c4\u5219\u6d3e\u751f\uff0c\u90a3\u4e48\u8f93\u5165\u8868\u8fbe\u5f0f\u4e2d\u6240\u6709\u663e\u5f0f\u6d3e\u751f\u7684\u6392\u5e8f\u89c4\u5219\u90fd\u5fc5\u987b\u76f8\u540c\uff0c\u5426\u5219\u4f1a\u62a5\u9519\u3002\u5982\u679c\u5b58\u5728\u663e\u5f0f\u6d3e\u751f\u7684\u6392\u5e8f\u89c4\u5219\uff0c\u90a3\u4e48\u6392\u5e8f\u89c4\u5219\u7ec4\u5408\u7684\u7ed3\u679c\u5c31\u662f\u8be5\u6392\u5e8f\u89c4\u5219\u3002</p>\n</li>\n<li class=\"listitem\" lang=\"zh\">\n<p>\u5426\u5219\uff0c\u6240\u6709\u8f93\u5165\u8868\u8fbe\u5f0f\u90fd\u5fc5\u987b\u5177\u6709\u76f8\u540c\u7684\u9690\u5f0f\u6392\u5e8f\u89c4\u5219\u6d3e\u751f\uff0c\u6216\u8005\u4e3a\u9ed8\u8ba4\u6392\u5e8f\u89c4\u5219\u3002\u5982\u679c\u5b58\u5728\u4efb\u4f55\u975e\u9ed8\u8ba4\u6392\u5e8f\u89c4\u5219\uff0c\u90a3\u4e48\u6392\u5e8f\u89c4\u5219\u7ec4\u5408\u7684\u7ed3\u679c\u5c31\u662f\u8be5\u6392\u5e8f\u89c4\u5219\uff1b\u5426\u5219\uff0c\u7ed3\u679c\u5c31\u662f\u9ed8\u8ba4\u6392\u5e8f\u89c4\u5219\u3002</p>\n</li>\n<li class=\"listitem\" lang=\"zh\">\n<p>\u5982\u679c\u8f93\u5165\u8868\u8fbe\u5f0f\u4e4b\u95f4\u5b58\u5728\u76f8\u4e92\u51b2\u7a81\u7684\u975e\u9ed8\u8ba4\u9690\u5f0f\u6392\u5e8f\u89c4\u5219\uff0c\u5219\u8be5\u7ec4\u5408\u4f1a\u88ab\u89c6\u4e3a\u5177\u6709\u4e0d\u786e\u5b9a\u6392\u5e8f\u89c4\u5219\u3002\u9664\u975e\u88ab\u8c03\u7528\u7684\u7279\u5b9a\u51fd\u6570\u786e\u5b9e\u9700\u8981\u77e5\u9053\u5b83\u5e94\u5f53\u4f7f\u7528\u54ea\u4e2a\u6392\u5e8f\u89c4\u5219\uff0c\u5426\u5219\u8fd9\u5e76\u4e0d\u662f\u9519\u8bef\u3002\u5982\u679c\u5b83\u786e\u5b9e\u9700\u8981\uff0c\u5c31\u4f1a\u5728\u8fd0\u884c\u65f6\u629b\u51fa\u9519\u8bef\u3002</p>\n</li>\n</ol>\n</div>\n<p lang=\"zh\">\u4f8b\u5982\uff0c\u8003\u8651\u5982\u4e0b\u8868\u5b9a\u4e49\uff1a</p>\n<pre class=\"programlisting\">CREATE TABLE test1 (\n    a text COLLATE \"de_DE\",\n    b text COLLATE \"es_ES\",\n    ...\n);\n</pre>\n<p lang=\"zh\">\u90a3\u4e48\u5728</p>\n<pre class=\"programlisting\">SELECT a &lt; 'foo' FROM test1;\n</pre>\n<p lang=\"zh\">\u4e2d\uff0c<code class=\"literal\">&lt;</code>\u6bd4\u8f83\u4f1a\u6309<code class=\"literal\">de_DE</code>\u89c4\u5219\u8fdb\u884c\uff0c\u56e0\u4e3a\u8be5\u8868\u8fbe\u5f0f\u7ec4\u5408\u4e86\u4e00\u4e2a\u9690\u5f0f\u6d3e\u751f\u7684\u6392\u5e8f\u89c4\u5219\u548c\u9ed8\u8ba4\u6392\u5e8f\u89c4\u5219\u3002\u4f46\u5728</p>\n<pre class=\"programlisting\">SELECT a &lt; ('foo' COLLATE \"fr_FR\") FROM test1;\n</pre>\n<p lang=\"zh\">\u4e2d\uff0c\u6bd4\u8f83\u4f1a\u6309<code class=\"literal\">fr_FR</code>\u89c4\u5219\u8fdb\u884c\uff0c\u56e0\u4e3a\u663e\u5f0f\u6392\u5e8f\u89c4\u5219\u6d3e\u751f\u8986\u76d6\u4e86\u9690\u5f0f\u6d3e\u751f\u3002\u8fdb\u4e00\u6b65\uff0c\u7ed9\u5b9a</p>\n<pre class=\"programlisting\">SELECT a &lt; b FROM test1;\n</pre>\n<p lang=\"zh\">\u89e3\u6790\u5668\u65e0\u6cd5\u786e\u5b9a\u5e94\u5f53\u5e94\u7528\u54ea\u4e2a\u6392\u5e8f\u89c4\u5219\uff0c\u56e0\u4e3a<code class=\"structfield\">a</code>\u5217\u548c<code class=\"structfield\">b</code>\u5217\u5177\u6709\u51b2\u7a81\u7684\u9690\u5f0f\u6392\u5e8f\u89c4\u5219\u3002\u7531\u4e8e <code class=\"literal\">&lt;</code>\u64cd\u4f5c\u7b26\u786e\u5b9e\u9700\u8981\u77e5\u9053\u8981\u4f7f\u7528\u54ea\u4e2a\u6392\u5e8f\u89c4\u5219\uff0c\u56e0\u6b64\u8fd9\u4f1a\u5bfc\u81f4\u4e00\u4e2a\u9519\u8bef\u3002\u8be5\u9519\u8bef\u53ef\u4ee5\u901a\u8fc7\u7ed9\u4efb\u4e00\u8f93\u5165\u8868\u8fbe\u5f0f\u9644\u52a0\u663e\u5f0f\u6392\u5e8f\u89c4\u5219\u8bf4\u660e\u7b26\u6765\u89e3\u51b3\uff0c\u4f8b\u5982\uff1a</p>\n<pre class=\"programlisting\">SELECT a &lt; b COLLATE \"de_DE\" FROM test1;\n</pre>\n<p lang=\"zh\">\u6216\u8005\u7b49\u4ef7\u5730\uff1a</p>\n<pre class=\"programlisting\">SELECT a COLLATE \"de_DE\" &lt; b FROM test1;\n</pre>\n<p lang=\"zh\">\u53e6\u4e00\u65b9\u9762\uff0c\u7ed3\u6784\u76f8\u4f3c\u7684\u60c5\u51b5</p>\n<pre class=\"programlisting\">SELECT a || b FROM test1;\n</pre>\n<p lang=\"zh\">\u4e0d\u4f1a\u5bfc\u81f4\u9519\u8bef\uff0c\u56e0\u4e3a<code class=\"literal\">||</code>\u64cd\u4f5c\u7b26\u4e0d\u5173\u5fc3\u6392\u5e8f\u89c4\u5219\uff1a\u65e0\u8bba\u4f7f\u7528\u4ec0\u4e48\u6392\u5e8f\u89c4\u5219\uff0c\u5176\u7ed3\u679c\u90fd\u76f8\u540c\u3002</p>\n<p lang=\"zh\">\u5982\u679c\u51fd\u6570\u6216\u64cd\u4f5c\u7b26\u8fd4\u56de\u7684\u662f\u652f\u6301\u6392\u5e8f\u89c4\u5219\u7684\u6570\u636e\u7c7b\u578b\uff0c\u90a3\u4e48\u5206\u914d\u7ed9\u8be5\u51fd\u6570\u6216\u64cd\u4f5c\u7b26\u7684\u8f93\u5165\u8868\u8fbe\u5f0f\u7ec4\u5408\u7684\u6392\u5e8f\u89c4\u5219\uff0c\u4e5f\u88ab\u8ba4\u4e3a\u9002\u7528\u4e8e\u5176\u7ed3\u679c\u3002\u56e0\u6b64\uff0c\u5728</p>\n<pre class=\"programlisting\">SELECT * FROM test1 ORDER BY a || 'foo';\n</pre>\n<p lang=\"zh\">\u4e2d\uff0c\u6392\u5e8f\u5c06\u6309<code class=\"literal\">de_DE</code>\u89c4\u5219\u8fdb\u884c\u3002\u4f46\u8fd9\u4e2a\u67e5\u8be2\uff1a</p>\n<pre class=\"programlisting\">SELECT * FROM test1 ORDER BY a || b;\n</pre>\n<p lang=\"zh\">\u4f1a\u62a5\u9519\uff0c\u56e0\u4e3a\u5373\u4f7f<code class=\"literal\">||</code>\u64cd\u4f5c\u7b26\u672c\u8eab\u4e0d\u9700\u8981\u77e5\u9053\u6392\u5e8f\u89c4\u5219\uff0c<code class=\"literal\">ORDER BY</code>\u5b50\u53e5\u4ecd\u7136\u9700\u8981\u3002\u4e0e\u4e4b\u524d\u4e00\u6837\uff0c\u53ef\u4ee5\u901a\u8fc7\u663e\u5f0f\u6392\u5e8f\u89c4\u5219\u8bf4\u660e\u7b26\u6765\u89e3\u51b3\u51b2\u7a81\uff1a</p>\n<pre class=\"programlisting\">SELECT * FROM test1 ORDER BY a || b COLLATE \"fr_FR\";\n</pre>\n</div>", "manual_path": "/docs/19/collation.html#COLLATION-CONCEPTS", "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"}, "comparison_data": {"scope": "Source provider identity; installation/build availability is separate", "provider": "builtin", "catalog_code": "b"}, "comparison_hash": "d0ee87b3545cc68aafaa491d16e6d3a73ddc2ded39dd20ba234b922cd06fd397", "manual_language": "zh"}, "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": "4d3346909b201ac1648232cf290462a7070c119326f56196f1f0253ed80fae41", "source_sha256": "4d3346909b201ac1648232cf290462a7070c119326f56196f1f0253ed80fae41", "catalog_fingerprint": "398fbb9f262264053c02fbf79f88be0a6770c1473faa6ecd5931d6ec41b8258b", "source_snapshot_utc": "26-Sep-2026 20:22"}, "sources": [{"url": "https://ftp.postgresql.org/pub/snapshot/dev/postgresql-snapshot.tar.bz2", "label": "Matching PostgreSQL source archive", "sha256": "4d3346909b201ac1648232cf290462a7070c119326f56196f1f0253ed80fae41"}, {"url": "https://pg.center/docs/devel/collation.html#COLLATION-CONCEPTS", "path": "collation.html", "label": "PostgreSQL 20 English manual", "sha256": "3a5f2e6c1df8548d2a7d1f654dfc8fe598c1ce90f62169c3a2d11d8c736f940e", "language": "en", "original_url": "/docs/devel/collation.html#COLLATION-CONCEPTS"}], "sections": [], "signature": "", "attributes": {"scope": "Source provider identity; installation/build availability is separate", "provider": "builtin", "catalog_code": "b"}, "description": ["builtin \u6392\u5e8f\u89c4\u5219\u63d0\u4f9b\u8005\u3002"], "manual_html": "<div class=\"sect2\" id=\"COLLATION-CONCEPTS\">\n<div class=\"titlepage\">\n<div>\n<div>\n<h3 class=\"title\" lang=\"zh\"><span class=\"sect2\"><a href=\"/docs/devel/collation.html#COLLATION-CONCEPTS\">23.2.1. \u6982\u5ff5</a></span></h3>\n</div>\n</div>\n</div>\n<p lang=\"zh\">\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=\"/docs/devel/glossary.html#GLOSSARY-DOMAIN\"></a><a class=\"glossterm\" href=\"/docs/devel/glossary.html#GLOSSARY-DOMAIN\" title=\"\u57df\">\u57df</a>\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</p>\n<p lang=\"zh\">\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</p>\n<p lang=\"zh\">\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 <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 <code class=\"function\">initcap</code>\uff09\u3001\u6a21\u5f0f\u5339\u914d\u64cd\u4f5c\u7b26\uff0c\u4ee5\u53ca<code class=\"function\">to_char</code> \u53ca\u76f8\u5173\u51fd\u6570\uff0c\u4e5f\u90fd\u4f1a\u8003\u8651\u6392\u5e8f\u89c4\u5219\u3002</p>\n<p lang=\"zh\">\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</p>\n<p lang=\"zh\">\u8868\u8fbe\u5f0f\u7684<em class=\"firstterm\">\u6392\u5e8f\u89c4\u5219\u6d3e\u751f</em>\u53ef\u4ee5\u662f\u663e\u5f0f\u7684\uff0c\u4e5f\u53ef\u4ee5\u662f\u9690\u5f0f\u7684\u3002\u8fd9\u4e00\u533a\u522b\u4f1a\u5f71\u54cd\u5f53\u4e00\u4e2a\u8868\u8fbe\u5f0f\u4e2d\u51fa\u73b0\u591a\u4e2a\u4e0d\u540c\u6392\u5e8f\u89c4\u5219\u65f6\uff0c\u7cfb\u7edf\u5982\u4f55\u628a\u5b83\u4eec\u7ec4\u5408\u8d77\u6765\u3002\u4f7f\u7528<code class=\"literal\">COLLATE</code>\u5b50\u53e5\u65f6\uff0c\u4f1a\u53d1\u751f\u663e\u5f0f\u6392\u5e8f\u89c4\u5219\u6d3e\u751f\uff1b\u5176\u4ed6\u6240\u6709\u6392\u5e8f\u89c4\u5219\u6d3e\u751f\u90fd\u662f\u9690\u5f0f\u7684\u3002\u5f53\u9700\u8981\u7ec4\u5408\u591a\u4e2a\u6392\u5e8f\u89c4\u5219\u65f6\uff0c\u4f8b\u5982\u5728\u51fd\u6570\u8c03\u7528\u4e2d\uff0c\u5c06\u4f7f\u7528\u4ee5\u4e0b\u89c4\u5219\uff1a</p>\n<div class=\"orderedlist\">\n<ol class=\"orderedlist\">\n<li class=\"listitem\" lang=\"zh\">\n<p>\u5982\u679c\u4efb\u4e00\u8f93\u5165\u8868\u8fbe\u5f0f\u5177\u6709\u663e\u5f0f\u6392\u5e8f\u89c4\u5219\u6d3e\u751f\uff0c\u90a3\u4e48\u8f93\u5165\u8868\u8fbe\u5f0f\u4e2d\u6240\u6709\u663e\u5f0f\u6d3e\u751f\u7684\u6392\u5e8f\u89c4\u5219\u90fd\u5fc5\u987b\u76f8\u540c\uff0c\u5426\u5219\u4f1a\u62a5\u9519\u3002\u5982\u679c\u5b58\u5728\u663e\u5f0f\u6d3e\u751f\u7684\u6392\u5e8f\u89c4\u5219\uff0c\u90a3\u4e48\u6392\u5e8f\u89c4\u5219\u7ec4\u5408\u7684\u7ed3\u679c\u5c31\u662f\u8be5\u6392\u5e8f\u89c4\u5219\u3002</p>\n</li>\n<li class=\"listitem\" lang=\"zh\">\n<p>\u5426\u5219\uff0c\u6240\u6709\u8f93\u5165\u8868\u8fbe\u5f0f\u90fd\u5fc5\u987b\u5177\u6709\u76f8\u540c\u7684\u9690\u5f0f\u6392\u5e8f\u89c4\u5219\u6d3e\u751f\uff0c\u6216\u8005\u4e3a\u9ed8\u8ba4\u6392\u5e8f\u89c4\u5219\u3002\u5982\u679c\u5b58\u5728\u4efb\u4f55\u975e\u9ed8\u8ba4\u6392\u5e8f\u89c4\u5219\uff0c\u90a3\u4e48\u6392\u5e8f\u89c4\u5219\u7ec4\u5408\u7684\u7ed3\u679c\u5c31\u662f\u8be5\u6392\u5e8f\u89c4\u5219\uff1b\u5426\u5219\uff0c\u7ed3\u679c\u5c31\u662f\u9ed8\u8ba4\u6392\u5e8f\u89c4\u5219\u3002</p>\n</li>\n<li class=\"listitem\" lang=\"zh\">\n<p>\u5982\u679c\u8f93\u5165\u8868\u8fbe\u5f0f\u4e4b\u95f4\u5b58\u5728\u76f8\u4e92\u51b2\u7a81\u7684\u975e\u9ed8\u8ba4\u9690\u5f0f\u6392\u5e8f\u89c4\u5219\uff0c\u5219\u8be5\u7ec4\u5408\u4f1a\u88ab\u89c6\u4e3a\u5177\u6709\u4e0d\u786e\u5b9a\u6392\u5e8f\u89c4\u5219\u3002\u9664\u975e\u88ab\u8c03\u7528\u7684\u7279\u5b9a\u51fd\u6570\u786e\u5b9e\u9700\u8981\u77e5\u9053\u5b83\u5e94\u5f53\u4f7f\u7528\u54ea\u4e2a\u6392\u5e8f\u89c4\u5219\uff0c\u5426\u5219\u8fd9\u5e76\u4e0d\u662f\u9519\u8bef\u3002\u5982\u679c\u5b83\u786e\u5b9e\u9700\u8981\uff0c\u5c31\u4f1a\u5728\u8fd0\u884c\u65f6\u629b\u51fa\u9519\u8bef\u3002</p>\n</li>\n</ol>\n</div>\n<p lang=\"zh\">\u4f8b\u5982\uff0c\u8003\u8651\u5982\u4e0b\u8868\u5b9a\u4e49\uff1a</p>\n<pre class=\"programlisting\">CREATE TABLE test1 (\n    a text COLLATE \"de_DE\",\n    b text COLLATE \"es_ES\",\n    ...\n);\n</pre>\n<p lang=\"zh\">\u90a3\u4e48\u5728</p>\n<pre class=\"programlisting\">SELECT a &lt; 'foo' FROM test1;\n</pre>\n<p lang=\"zh\">\u4e2d\uff0c<code class=\"literal\">&lt;</code>\u6bd4\u8f83\u4f1a\u6309<code class=\"literal\">de_DE</code>\u89c4\u5219\u8fdb\u884c\uff0c\u56e0\u4e3a\u8be5\u8868\u8fbe\u5f0f\u7ec4\u5408\u4e86\u4e00\u4e2a\u9690\u5f0f\u6d3e\u751f\u7684\u6392\u5e8f\u89c4\u5219\u548c\u9ed8\u8ba4\u6392\u5e8f\u89c4\u5219\u3002\u4f46\u5728</p>\n<pre class=\"programlisting\">SELECT a &lt; ('foo' COLLATE \"fr_FR\") FROM test1;\n</pre>\n<p lang=\"zh\">\u4e2d\uff0c\u6bd4\u8f83\u4f1a\u6309<code class=\"literal\">fr_FR</code>\u89c4\u5219\u8fdb\u884c\uff0c\u56e0\u4e3a\u663e\u5f0f\u6392\u5e8f\u89c4\u5219\u6d3e\u751f\u8986\u76d6\u4e86\u9690\u5f0f\u6d3e\u751f\u3002\u8fdb\u4e00\u6b65\uff0c\u7ed9\u5b9a</p>\n<pre class=\"programlisting\">SELECT a &lt; b FROM test1;\n</pre>\n<p lang=\"zh\">\u89e3\u6790\u5668\u65e0\u6cd5\u786e\u5b9a\u5e94\u5f53\u5e94\u7528\u54ea\u4e2a\u6392\u5e8f\u89c4\u5219\uff0c\u56e0\u4e3a<code class=\"structfield\">a</code>\u5217\u548c<code class=\"structfield\">b</code>\u5217\u5177\u6709\u51b2\u7a81\u7684\u9690\u5f0f\u6392\u5e8f\u89c4\u5219\u3002\u7531\u4e8e <code class=\"literal\">&lt;</code>\u64cd\u4f5c\u7b26\u786e\u5b9e\u9700\u8981\u77e5\u9053\u8981\u4f7f\u7528\u54ea\u4e2a\u6392\u5e8f\u89c4\u5219\uff0c\u56e0\u6b64\u8fd9\u4f1a\u5bfc\u81f4\u4e00\u4e2a\u9519\u8bef\u3002\u8be5\u9519\u8bef\u53ef\u4ee5\u901a\u8fc7\u7ed9\u4efb\u4e00\u8f93\u5165\u8868\u8fbe\u5f0f\u9644\u52a0\u663e\u5f0f\u6392\u5e8f\u89c4\u5219\u8bf4\u660e\u7b26\u6765\u89e3\u51b3\uff0c\u4f8b\u5982\uff1a</p>\n<pre class=\"programlisting\">SELECT a &lt; b COLLATE \"de_DE\" FROM test1;\n</pre>\n<p lang=\"zh\">\u6216\u8005\u7b49\u4ef7\u5730\uff1a</p>\n<pre class=\"programlisting\">SELECT a COLLATE \"de_DE\" &lt; b FROM test1;\n</pre>\n<p lang=\"zh\">\u53e6\u4e00\u65b9\u9762\uff0c\u7ed3\u6784\u76f8\u4f3c\u7684\u60c5\u51b5</p>\n<pre class=\"programlisting\">SELECT a || b FROM test1;\n</pre>\n<p lang=\"zh\">\u4e0d\u4f1a\u5bfc\u81f4\u9519\u8bef\uff0c\u56e0\u4e3a<code class=\"literal\">||</code>\u64cd\u4f5c\u7b26\u4e0d\u5173\u5fc3\u6392\u5e8f\u89c4\u5219\uff1a\u65e0\u8bba\u4f7f\u7528\u4ec0\u4e48\u6392\u5e8f\u89c4\u5219\uff0c\u5176\u7ed3\u679c\u90fd\u76f8\u540c\u3002</p>\n<p lang=\"zh\">\u5982\u679c\u51fd\u6570\u6216\u64cd\u4f5c\u7b26\u8fd4\u56de\u7684\u662f\u652f\u6301\u6392\u5e8f\u89c4\u5219\u7684\u6570\u636e\u7c7b\u578b\uff0c\u90a3\u4e48\u5206\u914d\u7ed9\u8be5\u51fd\u6570\u6216\u64cd\u4f5c\u7b26\u7684\u8f93\u5165\u8868\u8fbe\u5f0f\u7ec4\u5408\u7684\u6392\u5e8f\u89c4\u5219\uff0c\u4e5f\u88ab\u8ba4\u4e3a\u9002\u7528\u4e8e\u5176\u7ed3\u679c\u3002\u56e0\u6b64\uff0c\u5728</p>\n<pre class=\"programlisting\">SELECT * FROM test1 ORDER BY a || 'foo';\n</pre>\n<p lang=\"zh\">\u4e2d\uff0c\u6392\u5e8f\u5c06\u6309<code class=\"literal\">de_DE</code>\u89c4\u5219\u8fdb\u884c\u3002\u4f46\u8fd9\u4e2a\u67e5\u8be2\uff1a</p>\n<pre class=\"programlisting\">SELECT * FROM test1 ORDER BY a || b;\n</pre>\n<p lang=\"zh\">\u4f1a\u62a5\u9519\uff0c\u56e0\u4e3a\u5373\u4f7f<code class=\"literal\">||</code>\u64cd\u4f5c\u7b26\u672c\u8eab\u4e0d\u9700\u8981\u77e5\u9053\u6392\u5e8f\u89c4\u5219\uff0c<code class=\"literal\">ORDER BY</code>\u5b50\u53e5\u4ecd\u7136\u9700\u8981\u3002\u4e0e\u4e4b\u524d\u4e00\u6837\uff0c\u53ef\u4ee5\u901a\u8fc7\u663e\u5f0f\u6392\u5e8f\u89c4\u5219\u8bf4\u660e\u7b26\u6765\u89e3\u51b3\u51b2\u7a81\uff1a</p>\n<pre class=\"programlisting\">SELECT * FROM test1 ORDER BY a || b COLLATE \"fr_FR\";\n</pre>\n</div>", "manual_path": "/docs/devel/collation.html#COLLATION-CONCEPTS", "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"}, "comparison_data": {"scope": "Source provider identity; installation/build availability is separate", "provider": "builtin", "catalog_code": "b"}, "comparison_hash": "d0ee87b3545cc68aafaa491d16e6d3a73ddc2ded39dd20ba234b922cd06fd397", "manual_language": "zh"}}}, "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": "https://pg.center/docs/18/collation.html#COLLATION-CONCEPTS", "path": "collation.html", "label": "PostgreSQL 18 English manual", "sha256": "c98cbca2b2235a896f7fe438a88a99b8d6b9d1f50bdb49fe2794e9982a50797f", "language": "en", "original_url": "/docs/18/collation.html#COLLATION-CONCEPTS"}], "sections": [], "signature": "", "attributes": {"scope": "Source provider identity; installation/build availability is separate", "provider": "builtin", "catalog_code": "b"}, "description": ["builtin \u6392\u5e8f\u89c4\u5219\u63d0\u4f9b\u8005\u3002"], "manual_html": "<div class=\"sect2\" id=\"COLLATION-CONCEPTS\">\n<div class=\"titlepage\">\n<div>\n<div>\n<h3 class=\"title\" lang=\"zh\"><span class=\"sect2\"><a href=\"/docs/18/collation.html#COLLATION-CONCEPTS\">23.2.1. \u6982\u5ff5</a></span></h3>\n</div>\n</div>\n</div>\n<p lang=\"zh\">\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=\"/docs/18/glossary.html#GLOSSARY-DOMAIN\"></a><a class=\"glossterm\" href=\"/docs/18/glossary.html#GLOSSARY-DOMAIN\" title=\"\u57df\">\u57df</a>\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</p>\n<p lang=\"zh\">\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</p>\n<p lang=\"zh\">\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 <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 <code class=\"function\">initcap</code>\uff09\u3001\u6a21\u5f0f\u5339\u914d\u64cd\u4f5c\u7b26\uff0c\u4ee5\u53ca<code class=\"function\">to_char</code> \u53ca\u76f8\u5173\u51fd\u6570\uff0c\u4e5f\u90fd\u4f1a\u8003\u8651\u6392\u5e8f\u89c4\u5219\u3002</p>\n<p lang=\"zh\">\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</p>\n<p lang=\"zh\">\u8868\u8fbe\u5f0f\u7684<em class=\"firstterm\">\u6392\u5e8f\u89c4\u5219\u6d3e\u751f</em>\u53ef\u4ee5\u662f\u663e\u5f0f\u7684\uff0c\u4e5f\u53ef\u4ee5\u662f\u9690\u5f0f\u7684\u3002\u8fd9\u4e00\u533a\u522b\u4f1a\u5f71\u54cd\u5f53\u4e00\u4e2a\u8868\u8fbe\u5f0f\u4e2d\u51fa\u73b0\u591a\u4e2a\u4e0d\u540c\u6392\u5e8f\u89c4\u5219\u65f6\uff0c\u7cfb\u7edf\u5982\u4f55\u628a\u5b83\u4eec\u7ec4\u5408\u8d77\u6765\u3002\u4f7f\u7528<code class=\"literal\">COLLATE</code>\u5b50\u53e5\u65f6\uff0c\u4f1a\u53d1\u751f\u663e\u5f0f\u6392\u5e8f\u89c4\u5219\u6d3e\u751f\uff1b\u5176\u4ed6\u6240\u6709\u6392\u5e8f\u89c4\u5219\u6d3e\u751f\u90fd\u662f\u9690\u5f0f\u7684\u3002\u5f53\u9700\u8981\u7ec4\u5408\u591a\u4e2a\u6392\u5e8f\u89c4\u5219\u65f6\uff0c\u4f8b\u5982\u5728\u51fd\u6570\u8c03\u7528\u4e2d\uff0c\u5c06\u4f7f\u7528\u4ee5\u4e0b\u89c4\u5219\uff1a</p>\n<div class=\"orderedlist\">\n<ol class=\"orderedlist\">\n<li class=\"listitem\" lang=\"zh\">\n<p>\u5982\u679c\u4efb\u4e00\u8f93\u5165\u8868\u8fbe\u5f0f\u5177\u6709\u663e\u5f0f\u6392\u5e8f\u89c4\u5219\u6d3e\u751f\uff0c\u90a3\u4e48\u8f93\u5165\u8868\u8fbe\u5f0f\u4e2d\u6240\u6709\u663e\u5f0f\u6d3e\u751f\u7684\u6392\u5e8f\u89c4\u5219\u90fd\u5fc5\u987b\u76f8\u540c\uff0c\u5426\u5219\u4f1a\u62a5\u9519\u3002\u5982\u679c\u5b58\u5728\u663e\u5f0f\u6d3e\u751f\u7684\u6392\u5e8f\u89c4\u5219\uff0c\u90a3\u4e48\u6392\u5e8f\u89c4\u5219\u7ec4\u5408\u7684\u7ed3\u679c\u5c31\u662f\u8be5\u6392\u5e8f\u89c4\u5219\u3002</p>\n</li>\n<li class=\"listitem\" lang=\"zh\">\n<p>\u5426\u5219\uff0c\u6240\u6709\u8f93\u5165\u8868\u8fbe\u5f0f\u90fd\u5fc5\u987b\u5177\u6709\u76f8\u540c\u7684\u9690\u5f0f\u6392\u5e8f\u89c4\u5219\u6d3e\u751f\uff0c\u6216\u8005\u4e3a\u9ed8\u8ba4\u6392\u5e8f\u89c4\u5219\u3002\u5982\u679c\u5b58\u5728\u4efb\u4f55\u975e\u9ed8\u8ba4\u6392\u5e8f\u89c4\u5219\uff0c\u90a3\u4e48\u6392\u5e8f\u89c4\u5219\u7ec4\u5408\u7684\u7ed3\u679c\u5c31\u662f\u8be5\u6392\u5e8f\u89c4\u5219\uff1b\u5426\u5219\uff0c\u7ed3\u679c\u5c31\u662f\u9ed8\u8ba4\u6392\u5e8f\u89c4\u5219\u3002</p>\n</li>\n<li class=\"listitem\" lang=\"zh\">\n<p>\u5982\u679c\u8f93\u5165\u8868\u8fbe\u5f0f\u4e4b\u95f4\u5b58\u5728\u76f8\u4e92\u51b2\u7a81\u7684\u975e\u9ed8\u8ba4\u9690\u5f0f\u6392\u5e8f\u89c4\u5219\uff0c\u5219\u8be5\u7ec4\u5408\u4f1a\u88ab\u89c6\u4e3a\u5177\u6709\u4e0d\u786e\u5b9a\u6392\u5e8f\u89c4\u5219\u3002\u9664\u975e\u88ab\u8c03\u7528\u7684\u7279\u5b9a\u51fd\u6570\u786e\u5b9e\u9700\u8981\u77e5\u9053\u5b83\u5e94\u5f53\u4f7f\u7528\u54ea\u4e2a\u6392\u5e8f\u89c4\u5219\uff0c\u5426\u5219\u8fd9\u5e76\u4e0d\u662f\u9519\u8bef\u3002\u5982\u679c\u5b83\u786e\u5b9e\u9700\u8981\uff0c\u5c31\u4f1a\u5728\u8fd0\u884c\u65f6\u629b\u51fa\u9519\u8bef\u3002</p>\n</li>\n</ol>\n</div>\n<p lang=\"zh\">\u4f8b\u5982\uff0c\u8003\u8651\u5982\u4e0b\u8868\u5b9a\u4e49\uff1a</p>\n<pre class=\"programlisting\">CREATE TABLE test1 (\n    a text COLLATE \"de_DE\",\n    b text COLLATE \"es_ES\",\n    ...\n);\n</pre>\n<p lang=\"zh\">\u90a3\u4e48\u5728</p>\n<pre class=\"programlisting\">SELECT a &lt; 'foo' FROM test1;\n</pre>\n<p lang=\"zh\">\u4e2d\uff0c<code class=\"literal\">&lt;</code>\u6bd4\u8f83\u4f1a\u6309<code class=\"literal\">de_DE</code>\u89c4\u5219\u8fdb\u884c\uff0c\u56e0\u4e3a\u8be5\u8868\u8fbe\u5f0f\u7ec4\u5408\u4e86\u4e00\u4e2a\u9690\u5f0f\u6d3e\u751f\u7684\u6392\u5e8f\u89c4\u5219\u548c\u9ed8\u8ba4\u6392\u5e8f\u89c4\u5219\u3002\u4f46\u5728</p>\n<pre class=\"programlisting\">SELECT a &lt; ('foo' COLLATE \"fr_FR\") FROM test1;\n</pre>\n<p lang=\"zh\">\u4e2d\uff0c\u6bd4\u8f83\u4f1a\u6309<code class=\"literal\">fr_FR</code>\u89c4\u5219\u8fdb\u884c\uff0c\u56e0\u4e3a\u663e\u5f0f\u6392\u5e8f\u89c4\u5219\u6d3e\u751f\u8986\u76d6\u4e86\u9690\u5f0f\u6d3e\u751f\u3002\u8fdb\u4e00\u6b65\uff0c\u7ed9\u5b9a</p>\n<pre class=\"programlisting\">SELECT a &lt; b FROM test1;\n</pre>\n<p lang=\"zh\">\u89e3\u6790\u5668\u65e0\u6cd5\u786e\u5b9a\u5e94\u5f53\u5e94\u7528\u54ea\u4e2a\u6392\u5e8f\u89c4\u5219\uff0c\u56e0\u4e3a<code class=\"structfield\">a</code>\u5217\u548c<code class=\"structfield\">b</code>\u5217\u5177\u6709\u51b2\u7a81\u7684\u9690\u5f0f\u6392\u5e8f\u89c4\u5219\u3002\u7531\u4e8e <code class=\"literal\">&lt;</code>\u64cd\u4f5c\u7b26\u786e\u5b9e\u9700\u8981\u77e5\u9053\u8981\u4f7f\u7528\u54ea\u4e2a\u6392\u5e8f\u89c4\u5219\uff0c\u56e0\u6b64\u8fd9\u4f1a\u5bfc\u81f4\u4e00\u4e2a\u9519\u8bef\u3002\u8be5\u9519\u8bef\u53ef\u4ee5\u901a\u8fc7\u7ed9\u4efb\u4e00\u8f93\u5165\u8868\u8fbe\u5f0f\u9644\u52a0\u663e\u5f0f\u6392\u5e8f\u89c4\u5219\u8bf4\u660e\u7b26\u6765\u89e3\u51b3\uff0c\u4f8b\u5982\uff1a</p>\n<pre class=\"programlisting\">SELECT a &lt; b COLLATE \"de_DE\" FROM test1;\n</pre>\n<p lang=\"zh\">\u6216\u8005\u7b49\u4ef7\u5730\uff1a</p>\n<pre class=\"programlisting\">SELECT a COLLATE \"de_DE\" &lt; b FROM test1;\n</pre>\n<p lang=\"zh\">\u53e6\u4e00\u65b9\u9762\uff0c\u7ed3\u6784\u76f8\u4f3c\u7684\u60c5\u51b5</p>\n<pre class=\"programlisting\">SELECT a || b FROM test1;\n</pre>\n<p lang=\"zh\">\u4e0d\u4f1a\u5bfc\u81f4\u9519\u8bef\uff0c\u56e0\u4e3a<code class=\"literal\">||</code>\u64cd\u4f5c\u7b26\u4e0d\u5173\u5fc3\u6392\u5e8f\u89c4\u5219\uff1a\u65e0\u8bba\u4f7f\u7528\u4ec0\u4e48\u6392\u5e8f\u89c4\u5219\uff0c\u5176\u7ed3\u679c\u90fd\u76f8\u540c\u3002</p>\n<p lang=\"zh\">\u5982\u679c\u51fd\u6570\u6216\u64cd\u4f5c\u7b26\u8fd4\u56de\u7684\u662f\u652f\u6301\u6392\u5e8f\u89c4\u5219\u7684\u6570\u636e\u7c7b\u578b\uff0c\u90a3\u4e48\u5206\u914d\u7ed9\u8be5\u51fd\u6570\u6216\u64cd\u4f5c\u7b26\u7684\u8f93\u5165\u8868\u8fbe\u5f0f\u7ec4\u5408\u7684\u6392\u5e8f\u89c4\u5219\uff0c\u4e5f\u88ab\u8ba4\u4e3a\u9002\u7528\u4e8e\u5176\u7ed3\u679c\u3002\u56e0\u6b64\uff0c\u5728</p>\n<pre class=\"programlisting\">SELECT * FROM test1 ORDER BY a || 'foo';\n</pre>\n<p lang=\"zh\">\u4e2d\uff0c\u6392\u5e8f\u5c06\u6309<code class=\"literal\">de_DE</code>\u89c4\u5219\u8fdb\u884c\u3002\u4f46\u8fd9\u4e2a\u67e5\u8be2\uff1a</p>\n<pre class=\"programlisting\">SELECT * FROM test1 ORDER BY a || b;\n</pre>\n<p lang=\"zh\">\u4f1a\u62a5\u9519\uff0c\u56e0\u4e3a\u5373\u4f7f<code class=\"literal\">||</code>\u64cd\u4f5c\u7b26\u672c\u8eab\u4e0d\u9700\u8981\u77e5\u9053\u6392\u5e8f\u89c4\u5219\uff0c<code class=\"literal\">ORDER BY</code>\u5b50\u53e5\u4ecd\u7136\u9700\u8981\u3002\u4e0e\u4e4b\u524d\u4e00\u6837\uff0c\u53ef\u4ee5\u901a\u8fc7\u663e\u5f0f\u6392\u5e8f\u89c4\u5219\u8bf4\u660e\u7b26\u6765\u89e3\u51b3\u51b2\u7a81\uff1a</p>\n<pre class=\"programlisting\">SELECT * FROM test1 ORDER BY a || b COLLATE \"fr_FR\";\n</pre>\n</div>", "manual_path": "/docs/18/collation.html#COLLATION-CONCEPTS", "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"}, "comparison_data": {"scope": "Source provider identity; installation/build availability is separate", "provider": "builtin", "catalog_code": "b"}, "comparison_hash": "d0ee87b3545cc68aafaa491d16e6d3a73ddc2ded39dd20ba234b922cd06fd397", "manual_language": "zh"}, "comparison": {"left": "17", "right": "18", "status": "unchanged", "diff": ""}}