Re: [sqlite] Collation with concatenation

2011-12-15 Thread Dan Kennedy
On 12/15/2011 11:59 PM, Jeff Matthews wrote: This is in the documentation: CREATE TABLE t1( x INTEGER PRIMARY KEY, a, /* collating sequence BINARY */ b COLLATE BINARY, /* collating sequence BINARY */ c COLLATE RTRIM, /* collating sequence RTRIM */

[sqlite] Collation with concatenation

2011-12-15 Thread Jeff Matthews
This is in the documentation: CREATE TABLE t1( x INTEGER PRIMARY KEY, a, /* collating sequence BINARY */ b COLLATE BINARY, /* collating sequence BINARY */ c COLLATE RTRIM, /* collating sequence RTRIM */ d COLLATE NOCASE /* collating sequence NOCASE */