[sqlite] ICU Collator Base on Locale and Customize Rule

2011-03-27 Thread ashish yadav
Hi , If its possible to use Collator of ICU collation service which is base on both simultaneously : 1. Locale base like "ko_KR" ( coll = ucol_open("ko_KR", ) ) 2. Customized Rules ie "tailoring" ( coll = ucol_openRules(rlz, rlen, UCOL_OFF,UCOL_TERTIARY,NULL,) ) Collator_Final =

Re: [sqlite] Sorting of Korean Language Characters

2011-03-23 Thread ashish yadav
sorting base on Hangul Jamo or not ... Thanks & Regards Ashish On Wed, Mar 23, 2011 at 6:19 PM, Simon Slavin <slav...@bigfraud.org> wrote: > > On 23 Mar 2011, at 10:07am, ashish yadav wrote: > > > I think , Korean sorting base on Jamo(Hangul Jamo) is not supported

Re: [sqlite] Sorting of Korean Language Characters

2011-03-23 Thread ashish yadav
Hi Jean , I think , Korean sorting base on Jamo(Hangul Jamo) is not supported by ICU. May be i am wrong . I have gone through ICU user guide & its locale but not find any Hangul Jamo support by ICU Collation service. Yes, i got your mail ... Thanks for info... But I am working on Linux

[sqlite] Sorting of Korean Language Characters

2011-03-23 Thread ashish yadav
Hi , I am working on one application which require sorting for Korean Language. The Korean Characters sort by Jamo(Hangul Jamo) ie based on KSX1001 character code. Does sqlite3 or any other package support this type of sorting ? If not , then any clue to carry out this type of sorting ? Thanks

Re: [sqlite] How to get Unicode Value of any Character in string/text

2011-03-22 Thread ashish yadav
say if Character is kanji or Katakana or Hiragana ... Thanks & Regards Ashish On Tue, Mar 22, 2011 at 2:05 PM, Philip Graham Willoughby < phil.willoug...@strawberrycat.com> wrote: > On 22 Mar 2011, at 07:25, ashish yadav wrote: > > > Hi , > > > >

Re: [sqlite] How to get Unicode Value of any Character in string/text

2011-03-22 Thread ashish yadav
Hi , To be more specific that : 1. Database is UTF-8. 2. Programming Language is C or C++. Database may contain Chines / Japanese character of strings. So , if there is any way /APIs to know Unicode of Character ? Thanks & Regards Ashish On Tue, Mar 22, 2011 at 12:45 PM, as

[sqlite] How to get Unicode Value of any Character in string/text

2011-03-22 Thread ashish yadav
Hi , I want to know Unicode vale of Character given in string ( Like chines , Japanese etc) . If there is any API which can help in this ? Thanks & Regards Ashish ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] Sorting of Japanese Language

2011-03-21 Thread ashish yadav
Hi , I have looked into ICU , but ICU sort Japanese language using JIS x 4601(Japanese Industrial Standards). So, i am looking for other solution ... Thanks & Regards Ashish On Mon, Mar 21, 2011 at 6:15 PM, Igor Tandetnik <itandet...@mvps.org> wrote: > ashish yada

[sqlite] Sorting of Japanese Language

2011-03-21 Thread ashish yadav
Hi , I am working on one application which need Sorting in Japanese language. Sorting of Japanese needs to have Katakana and Kanji converted to Hiragana and then sorted according to the UTF-8 code. The Hiragana, Katakana, and Kanji characters shall be combined together and sorted by the Hiragana

Re: [sqlite] UTF-8 strings & ICU

2011-03-17 Thread ashish yadav
On Fri, Mar 18, 2011 at 10:06 AM, Igor Tandetnik <itandet...@mvps.org>wrote: > On 3/18/2011 12:27 AM, ashish yadav wrote: > > My application is using UTF-8 strings ie database contain UTF-8 strings. > > For sorting requirement of application ,i use ICU which is integrated

[sqlite] UTF-8 strings & ICU

2011-03-17 Thread ashish yadav
Hi, My application is using UTF-8 strings ie database contain UTF-8 strings. For sorting requirement of application ,i use ICU which is integrated with sqlite3. Now ICU support UTF-16 encode string for its operation. Can any one please tell me how to deal with this situation ? If ICU/Sqlite3

[sqlite] How to use customize Rules & specific locale simultaneously for Sorting using ICU

2011-01-09 Thread ashish yadav
Hi , For sorting , ICU use locale base sorting. Locale can be given using ucol_open(const char* loc,UErrorCode* status) function/API like : collator = ucol_open(en_US, ) Now i want to customize collation rule also like : const static char* rule = "& f < a " ; Now, for this customize rule ,