tags:

views:

36

answers:

0
Q: 

Android sqlite: order by to sort international characters

Hi,

I have a android database and it has a column called 'name'.'Name' column can have international characters. Now when I query this database, I want to sort the name column. The sort should consider international characters while sorting. I have read that there is a UNICODE collator for android but I am not able to use it in queries. Anybody has an idea how to use UNICODE collator. Can I really use UNICODE collator for sorting ? Any pointers will be appreciated.

related questions

Sort with one option forced to top of list
is Microsoft sort.exe able to sort unicode UTF-16 (LE) files?
Alphanumeric Sorting
How to set the header sort glyph in a .NET ListView?
How can I sort by multiple conditions with different orders?
In Python how do I sort a list of dictionaries by values of the dictionary?
Rosetta Stone - Sorting Arrays
In Python, how can you easily retrieve sorted items from a dictionary?
xslt: apply-templates in reverse order
What is the most efficient way to sort an Html Select's Options by value, while preserving the currently selected item?
How to do multi-column sorting on a Visual Basic 6 ListView?
Best way to sort an array in delphi
How do I sort a list of strings in Python?
Comparison of Lat, Long Coordinates
Natural Sorting algorithm
Natural (human alpha-numeric) sort in Microsoft SQL 2005
Why doesn't **sort** sort the same on every machine?
How do I write a sort worse than O(n!)
An O(1) Sort ~~~
Sorting an IList in C#
How does one rank an array (sort) by value? *With a twist*
Rigor in capturing test cases for unit testing
Merge Sort a Linked List
graph serialization
How do you sort a C# dictionary by value?