Hi Tandetnik,
Actually i want to support Multilingual Linguistic Sorts.
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(language) letters.
The digits shall be sorted below the special characters and the letters
shall be sorted below the digits.
So i think,to achieve this we have to provide collation base on :
a.locale
b. customize collation rule ie "tailoring".
But i don't know how to use both at same time in sqlite3 as locale base
collation use ucol_open() & customize collation rule use ucol_openRules().
Please correct me if i am wrong here .
Also :
a.How to customize Collation Rule for the same ?
b.If any locale work for same requirement ?
Thanks & Regards
Ashish
"Be a Part of Solution"
On Tue, Dec 28, 2010 at 10:06 PM, Igor Tandetnik <[email protected]>wrote:
> ashish yadav <[email protected]> wrote:
> > We can use ICU collation to sort text base on locale by using :
> > a. .load './libSqliteIcu.so'
> > b. SELECT icu_load_collation('en_EN', 'ENGLISH');
> > c.SELECT * FROM Persons ORDER BY LastName COLLATE ENGLISH;
> >
> > But now i want to customize ICU Collation rule & then use it with
> Sqlite3.
>
> What do you mean, customize? What exactly do you have in mind?
> --
> Igor Tandetnik
>
> _______________________________________________
> 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
