Vinicius wrote: we did a query in SQLlite, but the result is not in the order that we need, > ie, the character "á" is being shown after z. > > How can I configure my query to ignore special characters >
Which characters are "special" to you? It's kind of hard to spell certain words without certain accented characters, for example, "voilà". 'getNumericValue()' is a bad idea. It doesn't correspond to collation order. 'Ⅼ' will return 50. 'Ⅻ' will return 12. There are methods to deal with collation order in Java in case the SQLite functions are just too "lite". It's a big topic. -- Lew -- You received this message because you are subscribed to the Google Groups "Android Developers" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/android-developers?hl=en
