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
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;
|