Hi Trausti,
Maybe the collating sequence attribute can help, see this url:
http://www.sqlite.org/datatype3.html#collation
Greetings,
Andre
Trausti Thor Johannsson wrote:
How do I get sqlite to sort correctly when using UTF8 chars ? In
icelandic, we have the alphabet, AÁBCDÐEÉFGHIÍ...., so you see that
all letters like A,E,I,O,U have a brother character with a comma on
top of it. Currently it sorts all comma based charaters after Z, and
also we have a few other characters like ÐÆÞÖ (hope you see them).
So you hopefully understand my dilemma, I need to sort them
correctly, preferably without writing my own sort routine.
Hope to get a good answer,
Trausti_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
