liamlambert wrote:
I have a search stack that searches an SQLlite database the database
is case sensitive
does anyone know of a way around this
setting the "set the caseSensitive to false" does not work
Right - that affects comparisons made within your script; I assume you
are doing the search using SQLite, and that wouldn't be affected by this
setting.
AFAIK (and I am NOT an SQLite expert), SQLite doesn't have a way to set
comparisons to use case insensitive; I have seen the recommendation to
use "LIKE" instead - e.g. instead of
SELECT 'HELLO' = 'hello' results in 0
you would do
SELECT 'HELLO' LIKE 'hello' results in 1
--
Alex Tweedly http://www.tweedly.net
--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.375 / Virus Database: 267.14.21/236 - Release Date: 20/01/2006
_______________________________________________
use-revolution mailing list
[email protected]
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution
