On Thu, May 01, 2008 at 10:45:17AM -0300, Francisco Ares scratched on the wall: > Hello > > I know it has already been discussed, but I could not find a detailed > and final answer:
This is well documented: http://www.sqlite.org/lang_expr.html Read the section on the 'LIKE' operator. It is pretty clear about how LIKE works and that the case-insensitive behavior only applies to 7-bit Latin characters. This is considered a bug, but is likely to be "unfixed" for a long time. > Could anyone give me a hint on how to set up the database creation and > further openings, and how should be the SELECT query to match both > upper and lower case of accented words? As the document referenced above explains, you can create a user function called "like(A,B)" that will over-ride the built-in behavior for LIKE. If you're only dealing with one language, such as Brazilian-Portuguese, then you can just custom code the various accented characters used in that specific language. -j -- Jay A. Kreibich < J A Y @ K R E I B I.C H > "'People who live in bamboo houses should not throw pandas.' Jesus said that." - "The Ninja", www.AskANinja.com, "Special Delivery 10: Pop!Tech 2006" _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users