bug report (INSTR() ignores NOCASE on columns)

Stephan Senzel <mail-280D0R3wBv8cwMQM/[email protected]> Sun, 2 Feb 2020 14:12:04 +0100

Newsgroups	gmane.comp.db.sqlite.general
Message-ID	<[email protected]>

INSTR() ignores NOCASE on columns

-----------------------

example:

SELECT * FROM table WHERE INSTR(column, ' castle ') > 0

returns datasets with 'castle' only, without 'Castle', even if the 
column is set to NOCASE

-----------------------

LIKE doesn't have this problem, works well

SELECT * FROM table WHERE column LIKE '% castle %'

returns 'castle' and 'Castle' when column is set to NOCASE
_______________________________________________
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users