[android-developers] Re: Sqllite order by

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 android-developers@googlegroups.com
To unsubscribe from this group, send email to
android-developers+unsubscribe@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/android-developers?hl=en