Hi ! Sorry, I dont know English very well ...:(
I need to get all rows with acents on some colums : SELECT ...FROM ... WHERE some_col LIKE 'sao paulo' and get : 'são Paulo', 'sao Paulo', 'são Paúlo', etc in other words, function LIKE consider : ã, â, á etc equal 'a' . I am thinking to do a copy of the function sqliteLikeCompare (in func.c) and change the use of UpperToLower to another function that converters acents to non acents caracter ... but I am not shure if this is the correct place / thing to do ! With this change, SQLite will behave like MySQL, and for people who use acents in their languages this helps A LOT !! Someone alredy did this ? Change UpperToLower will resolve this problem ? Thanks Rubens Jr. -- Mensagens enviadas estão livres de vírus. Verificado por AVG Anti-Vírus (http://www.grisoft.com). Version: 7.0.224 / Virus Database: 261.9.8 - Release Date: 24/02/2004 --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]