On Jan 26, 2005, at 8:56 AM, 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?
I realized that I left out creation of the view. It was
sqlite> create view va as select b from a;
Do I need a COLLATE expression in the view declaration, too? I couldn't get it to work without getting a syntax error:
sqlite> create view va as select b COLLATE nocase from a; SQL error: near "COLLATE": syntax error
Any help would be greatly appreciated.
Regards,
David
