Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Further clarification that collating functions only work on string values. |
|---|---|
| Timelines: | family | ancestors | descendants | both | branch-3.30 |
| Files: | files | file ages | folders |
| SHA3-256: |
ba755cbcaa2e3dc3228b0edbfc4b0f44 |
| User & Date: | drh 2020-01-08 11:12:47 |
Context
|
2020-01-22
| ||
| 19:04 | Version 3.31.0 check-in: 44e1ce5453 user: drh tags: trunk, release, version-3.31.0 | |
|
2020-01-08
| ||
| 11:12 | Further clarification that collating functions only work on string values. Leaf check-in: ba755cbcaa user: drh tags: branch-3.30 | |
|
2019-12-14
| ||
| 11:02 | Fix typo on the schema_version pragma documentation. check-in: 2a413e2e3e user: drh tags: branch-3.30 | |
Changes
Changes to pages/datatype3.in.
609 610 611 612 613 614 615 616 617 618 619 620 621 622 |
<li>^(<b>RTRIM</b> - The same as binary, except that trailing space
characters are ignored.)^</li>
</ul>
<p>An application can register additional collating functions using
the [sqlite3_create_collation()] interface.</p>
<h2>Assigning Collating Sequences from SQL</h2>
<p>
^Every column of every
table has an associated collating function. ^If no collating function
is explicitly defined, then the collating function defaults to BINARY.
|
> > > > |
609 610 611 612 613 614 615 616 617 618 619 620 621 622 623 624 625 626 |
<li>^(<b>RTRIM</b> - The same as binary, except that trailing space
characters are ignored.)^</li>
</ul>
<p>An application can register additional collating functions using
the [sqlite3_create_collation()] interface.</p>
<p>Collating functions only matter when comparing string values.
Numeric values are always compared numerically, and BLOBs are always
compared byte-by-byte using memcmp().</p>
<h2>Assigning Collating Sequences from SQL</h2>
<p>
^Every column of every
table has an associated collating function. ^If no collating function
is explicitly defined, then the collating function defaults to BINARY.
|