/ Check-in [bd6876a1]
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:Remove mention of the REVERSE collating sequence from the documentation. (CVS 3159)
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1:bd6876a1a946a9b266b31d776081464de7c7f437
User & Date: drh 2006-04-01 14:38:41
Context
2006-04-02
11:57
Do not strip windows DLLs because this prevents them from being relocatable. Ticket #1474. (CVS 3160) check-in: 94054cd9 user: drh tags: trunk
2006-04-01
14:38
Remove mention of the REVERSE collating sequence from the documentation. (CVS 3159) check-in: bd6876a1 user: drh tags: trunk
2006-03-29
00:24
Properly record the names of triggers even if the name is quoted. Ticket #1737. (CVS 3158) check-in: 4ba280dd user: drh tags: trunk
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to www/datatype3.tcl.

     1         -set rcsid {$Id: datatype3.tcl,v 1.12 2006/01/26 13:25:08 danielk1977 Exp $}
            1  +set rcsid {$Id: datatype3.tcl,v 1.13 2006/04/01 14:38:41 drh Exp $}
     2      2   source common.tcl
     3      3   header {Datatypes In SQLite Version 3}
     4      4   puts {
     5      5   <h2>Datatypes In SQLite Version 3</h2>
     6      6   
     7      7   <h3>1. Storage Classes</h3>
     8      8   
................................................................................
   308    308   comparison is determined using memcmp(), regardless of the encoding of the
   309    309   string. SQLite v3 provides the ability for users to supply arbitrary
   310    310   comparison functions, known as user-defined collation sequences, to be used
   311    311   instead of memcmp().
   312    312   </p>  
   313    313   <p>
   314    314   Aside from the default collation sequence BINARY, implemented using
   315         -memcmp(), SQLite features two extra built-in collation sequences 
   316         -intended for testing purposes, NOCASE and REVERSE:
          315  +memcmp(), SQLite features one extra built-in collation sequences 
          316  +intended for testing purposes, the NOCASE collation:
   317    317   </p>  
   318    318   <UL>
   319    319   	<LI><b>BINARY</b> - Compares string data using memcmp(), regardless
   320    320                               of text encoding.</LI>
   321         -	<LI><b>REVERSE</b> - Collate in the reverse order to BINARY. </LI>
   322    321   	<LI><b>NOCASE</b> - The same as binary, except the 26 upper case
   323    322   			    characters used by the English language are
   324    323   			    folded to their lower case equivalents before
   325    324                               the comparison is performed.  </UL>
   326    325   
   327    326   
   328    327   <h4>7.1 Assigning Collation Sequences from SQL</h4>