Thanks Jay. francisco
On Thu, May 1, 2008 at 11:09 AM, Jay A. Kreibich <[EMAIL PROTECTED]> wrote: > 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 > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users