/ Check-in [1658ea53]
Login

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

Overview
Comment:Fix an error in the collation sequence examples in datatype3.html. Ticket #1641. (CVS 3032)
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1:1658ea53c929f26741d788d170368d37ae5fd105
User & Date: danielk1977 2006-01-26 13:25:08
Context
2006-01-26
14:29
Enhanced comments on the opcode.h building script. (CVS 3033) check-in: 7ccebf68 user: drh tags: trunk
13:25
Fix an error in the collation sequence examples in datatype3.html. Ticket #1641. (CVS 3032) check-in: 1658ea53 user: danielk1977 tags: trunk
13:11
Add omittest.tcl script to automate testing compile-time OMIT symbols. (CVS 3031) check-in: 540d28a7 user: danielk1977 tags: trunk
Changes
Hide Diffs Unified Diffs Ignore Whitespace Patch

Changes to www/datatype3.tcl.

1
2
3
4
5
6
7
8
...
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
set rcsid {$Id: datatype3.tcl,v 1.11 2005/09/17 02:34:05 drh Exp $}
source common.tcl
header {Datatypes In SQLite Version 3}
puts {
<h2>Datatypes In SQLite Version 3</h2>

<h3>1. Storage Classes</h3>

................................................................................
    d COLLATE NOCASE   -- default collation type NOCASE
);

-- Text comparison is performed using the BINARY collation sequence.
SELECT (a = b) FROM t1;

-- Text comparison is performed using the NOCASE collation sequence.
SELECT (a = d) FROM t1;

-- Text comparison is performed using the BINARY collation sequence.
SELECT (d = a) FROM t1;

-- Text comparison is performed using the REVERSE collation sequence.
SELECT ('abc' = c) FROM t1;

-- Text comparison is performed using the REVERSE collation sequence.
SELECT (c = 'abc') FROM t1;

|







 







|


|







1
2
3
4
5
6
7
8
...
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
set rcsid {$Id: datatype3.tcl,v 1.12 2006/01/26 13:25:08 danielk1977 Exp $}
source common.tcl
header {Datatypes In SQLite Version 3}
puts {
<h2>Datatypes In SQLite Version 3</h2>

<h3>1. Storage Classes</h3>

................................................................................
    d COLLATE NOCASE   -- default collation type NOCASE
);

-- Text comparison is performed using the BINARY collation sequence.
SELECT (a = b) FROM t1;

-- Text comparison is performed using the NOCASE collation sequence.
SELECT (d = a) FROM t1;

-- Text comparison is performed using the BINARY collation sequence.
SELECT (a = d) FROM t1;

-- Text comparison is performed using the REVERSE collation sequence.
SELECT ('abc' = c) FROM t1;

-- Text comparison is performed using the REVERSE collation sequence.
SELECT (c = 'abc') FROM t1;