On Jan 23, 2005, at 7:29 PM, David Wheeler wrote:
sqlite> create table a(b text COLLATE nocase);
sqlite> insert into a values ('this');
sqlite> insert into a values ('This');
sqlite> insert into a values ('THIS');
sqlite> select * from a where b = 'this';
this
This
THIS
sqlite>
Hrm, I'f finding that the collation isn't respected by views:
sqlite> select * from va where b = 'this';
b
----------
this
How do I get views to respect the collation?
Many TIA,
David
--
David Wheeler
President, Kineticode, Inc.
http://www.kineticode.com/
Kineticode. Setting knowledge in motion.[sm]
