Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Update the NOCASE documentation to make it clear that it uses sqlite3_strnicmp() for comparison and thus stops at the first embedded zero character in the string. |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA3-256: |
e751b0c91a80dd319d4be952dd591b81 |
| User & Date: | drh 2020-03-06 00:13:15 |
Context
|
2020-03-15
| ||
| 18:17 | Enhance althttpd to support Range: attributes in the HTTP request header. (check-in: 1d3579379c user: drh tags: trunk) | |
|
2020-03-06
| ||
| 00:13 | Update the NOCASE documentation to make it clear that it uses sqlite3_strnicmp() for comparison and thus stops at the first embedded zero character in the string. (check-in: e751b0c91a user: drh tags: trunk) | |
|
2020-03-04
| ||
| 20:27 | Small update to deterministic.html to mention generated columns. (check-in: 37b0c51a67 user: drh tags: trunk) | |
Changes
Changes to pages/datatype3.in.
| ︙ | ︙ | |||
597 598 599 600 601 602 603 |
string is greater or if the two strings are equal.
^SQLite has three built-in collating functions: BINARY, NOCASE, and
RTRIM.</p>
<ul>
<li>^(<b>BINARY</b> - Compares string data using memcmp(), regardless
of text encoding.</li>)^
| | > | > > | 597 598 599 600 601 602 603 604 605 606 607 608 609 610 611 612 613 614 615 616 617 618 |
string is greater or if the two strings are equal.
^SQLite has three built-in collating functions: BINARY, NOCASE, and
RTRIM.</p>
<ul>
<li>^(<b>BINARY</b> - Compares string data using memcmp(), regardless
of text encoding.</li>)^
<li>^(<b>NOCASE</b> - Similar to binary, except that it uses
[sqlite3_strnicmp()] for the comparison. Hence the 26 upper case
characters of ASCII are folded to their lower case equivalents before
the comparison is performed.)^ Note that only ASCII characters
are case folded. SQLite does not attempt to do full
UTF case folding due to the size of the tables required.
Also note that any U+0000 characters in the string are considered
string terminators for comparison purposes.
<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>
|
| ︙ | ︙ |