Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
Comment: | Further clarification that collating functions only work on string values. |
---|---|
Downloads: | Tarball | ZIP archive |
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.615 |
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. |
︙ | ︙ |