Re: [sqlite] Sorting of Korean Language Characters

2011-03-23 Thread ashish yadav
Hi Simon , Yes , i try .but got mix result of sorted strings. I have one sorted stings sequence base on Hangul Jamo like : 1. 서산 2. 서울 3. 수원 4. 순천 But this same sequence , i not got when i use : SELECT icu_load_collation('ko_KR', 'KOREAN'); So that why i can't say if ICU support

Re: [sqlite] Sorting of Korean Language Characters

2011-03-23 Thread Simon Slavin
On 23 Mar 2011, at 10:07am, ashish yadav wrote: > 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. Let's get this straight. Have

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

Re: [sqlite] Sorting of Korean Language Characters

2011-03-23 Thread Jean-Christophe Deschamps
At 09:43 23/03/2011, you wrote: >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

[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