sqlite case insensitive matching

[William Siegrist]

On Mar 2, 2010, at 1:13 PM, Joshua Root wrote:

> Can anyone advise the best way to match against a column in sqlite in a
> case-insensitive but otherwise exact manner? This is specifically for
> port names in the registry.
> 


You mean you want to test "WHERE name LIKE 'apache'" and also match 'Apache' and 'APACHE'? Case-insensitive is the default for LIKE comparisons for ASCII characters in sqlite. 

-Bill