On 2017/01/11 11:19 PM, Darren Duncan wrote:
On 2017-01-11 10:11 AM, Jens Alfke wrote:
And while we’re at it, I’d like to see a case-insensitive string
equality operator.
Yes, that shorthand can be useful. But don't make it a pragma that
overrides the meaning of "=", which would be a world of hurt, it needs
a different name. -- Darren Duncan
Doesn't this already do the trick?
SELECT a FROM t WHERE a = b COLLATE NOCASE;
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users