On 3 Jan 2011, at 11:08am, ashish yadav wrote: > I want to sort Special Characters,Digits, Latin and Greek > Characters(language independent sorting order) using ICU collation. > > > The sorting order shall be approached by separating the character set into > three groups: > a. special characters (i.e. +, -, &, Space, etc.) > b. digits (0-9) > c. Latin/Greek letters. > The digits shall be sorted below the special characters and the letters > shall be sorted below the digits.
Your two statements contradict each-other. You cannot both sort by ICU collation and obey your rules a, b, and c, because ICU collation contains its own rules on how to treat latin letters and some special characters, and they don't match the rules you stated. Pick one or the other. If you want to use ICU collation, then you can use the standard ICU extension. If you want to use rules a, b, and c, then you will have to write your own collation. Simon. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
