Hi Simon ,
Thanks for info.
But i think , we can customize ICU Collation Rule.
The same thing i try to do.
At First customize rule , i didn't get success ; but at 2nd customize rule i
get success( please see the my previous mail)....
So i want to know what is wrong with First customize rule ?
Can you please see & let me know ?
Thanks & Regards
Ashish
"Be a Part of Solution"
On Mon, Jan 3, 2011 at 7:35 PM, Simon Slavin <[email protected]> wrote:
>
> 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
>
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
