> On Jan 11, 2017, at 9:55 AM, Anony Mous <[email protected]> wrote:
>
> Textual data has case. Sometimes that matters. Sometimes it doesn't. A
> database engine should be able to cleanly deal with that without forcing
> the programmer to write custom code.
+1. And while we’re at it, I’d like to see a case-insensitive string equality
operator.
> SELECT trim(name) FROM names WHERE name LIKE('Ben') and name
> ILIKE('benjamin')
>
> ...you can't do that in SqLite using a pragma, can you? If you can, I'd
> sure like to learn how.
But to play devil’s advocate, you _can_ do that with:
SELECT trim(name) FROM names WHERE name LIKE('Ben') and lower(name)
LIKE('benjamin’)
—Jens
_______________________________________________
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
