David, No, you can't specify a collation when creating a view (http://www.sqlite.org/lang_createview.html). I don't know whether is was intentional that simple columns in a view don't get collation info from the base table, but if you think it's a bug, you can submit a bug ticket; meanwhile, there are work- arounds.
For sorting, you can specify a collation ... order by b collate nocase If all you need is caseless comparison, you can use select * from va where lower(b) = 'this' If you need a more complicated comparison, you'll probably have to write a comparison function: select * from va where mycomp(b, x) = 0 Regards
