On Feb 12, 2008 9:17 PM, Mahalakshmi.m <[EMAIL PROTECTED]> wrote: > Hi, > I am working in 3.3.6 > > My database looks as follows: > "Create table MUSIC (id integer primary key,Track text);" > > I have inserted some Japanese records inside and I tried to list all the > tracks sorted by Tracks. > > "select Tracks from MUSIC order by Track;" [ All records are Japanese Full > Size Katakana ] >
If you aren't getting the expected results you might try creating a custom collation. But afaik hiragana and katakana should both sort fine, as both are in lexicographical order (ie, あかさたなはまやらわ) which is what sqlite uses by default. -- Cory Nelson _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
