Documentation Source Text

Check-in [ba755cbcaa]
Login

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 | branch-3.30
Files: files | file ages | folders
SHA3-256: ba755cbcaa2e3dc3228b0edbfc4b0f4437c5d5f5b6a37ac43b41141c7e970270
User & Date: drh 2020-01-08 11:12:47
Context
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
Hide Diffs Unified Diffs Ignore Whitespace Patch

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.