Is it possible to use a collate type of function when searching my database. I can order it correctly using a collate so that all of my names starting with e are along side those starting with accented e etc.
i.e select * from <table> order by <name> collate <collation> ; would result in aaaa eeee éééé zzzz without the collate I obviously get: aaaa eeee zzzz éééé Hwever, what I want to do is seach for all of these varients too, i.e. so that if I search for e that I get all of the e and accented e' etc, is this possble using something like the collation, or do I need to specify all of them individually? Thanks _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
