Re: [sqlite] bug report (INSTR() ignores NOCASE on columns)

Stephan Senzel, on Sunday, February 2, 2020 08:12 AM, wrote... > > 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

[sqlite] bug report (INSTR() ignores NOCASE on columns)

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