Re: [sqlite] Is this Sorting order right?

2008-05-15 Thread Igor Tandetnik
"Mahalakshmi.m" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > I will call this loop 2 times for inserting 2 records at run time. Which part of "the exact code" is difficult to understand? Can you post the code that I can copy, paste, compile, run and see the results for mysel

[sqlite] Is this Sorting order right?

2008-05-15 Thread Mahalakshmi.m
typedef struct {   unsigned short s8_ArtistName[256];   }STRUCT_SQLITE_MY_RECORD;  UINT32   u32_Return;  const UINT16 *u16_SearchResult;  STRUCT_SQLITE_MY_RECORD st_SQLITE_DB_Record; sqlite3* db;  sqlite3_stmt*

Re: [sqlite] Is this Sorting order right?

2008-05-14 Thread Igor Tandetnik
Mahalakshmi.m <[EMAIL PROTECTED]> wrote: > unsigned short ArtistName; > sqlite3_bind_text16(insert,1,ArtistName,-1,SQLITE_STATIC); Doesn't compile. The third parameter of sqlite3_bind_text16 is a void*, and you are passing unsigned short there. You might have meant &ArtistName, except that the

[sqlite] Is this Sorting order right?

2008-05-14 Thread Mahalakshmi.m
Igor Tandetnik wrote: >I'm not sure I understand. What exactly are you doing differently in these >two cases? Can you quote the exact code that fails, in full? #include #include int main()  {   sqlite3* db;   sqlite3_stmt* insert;  unsigned short ArtistName;   sqlite3_open(" mysqlite.db ", &d

Re: [sqlite] Is this Sorting order right?

2008-05-13 Thread Igor Tandetnik
"Mahalakshmi.m" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Igor Tandetnik wrote >>> I can't reproduce this particular problem. Here's the test I wrote: >>> Figure out what you are doing differently. > > I too did the same using both UTF8 anf UTF16 .Its coming right for > UTF8 but

[sqlite] Is this Sorting order right?

2008-05-12 Thread Mahalakshmi.m
Igor Tandetnik wrote >> I can't reproduce this particular problem. Here's the test I wrote: >> Figure out what you are doing differently. I too did the same using both UTF8 anf UTF16 .Its coming right for UTF8 but its wrong for UTF16. For both encoding I used the below procedure, sqlite3_prepare(

Re: [sqlite] Is this Sorting order right?

2008-05-12 Thread Igor Tandetnik
Mahalakshmi.m <[EMAIL PROTECTED]> wrote: > What about Japanese Kanji? > Will sqlite sort all the Hiragana,Katakana,Kanji. > I am having some records with starting Unicode as follows. > > 6B4C Kanji 25 1 > 30A2 Katakana > > I am storing it using sqlite3_bind_text16(). > > But

Re: [sqlite] Is this Sorting order right?

2008-05-12 Thread Bob Ebert
ort by the "bar" column or use an index built on that column. --Bob -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mahalakshmi.m Sent: Monday, May 12, 2008 7:21 AM To: Sqlite User Subject: [

[sqlite] Is this Sorting order right?

2008-05-12 Thread Mahalakshmi.m
Mahalakshmi wrote > What about Japanese Kanji? > Will sqlite sort all the Hiragana,Katakana,Kanji. Igor Tandetnik wrote >> Not out of the box. You will have to implement a custom collation. Or, >> you can build SQLite with ICU support, then it >> will use ICU collation >> functions. Thanks a

Re: [sqlite] Is this Sorting order right?

2008-05-10 Thread Igor Tandetnik
"Mahalakshmi.m" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > What about Japanese Kanji? > > Will sqlite sort all the Hiragana,Katakana,Kanji. Not out of the box. You will have to implement a custom collation. Or, you can build SQLite with ICU support, then it will use ICU collatio

[sqlite] Is this Sorting order right?

2008-05-10 Thread Mahalakshmi.m
What about Japanese Kanji? Will sqlite sort all the Hiragana,Katakana,Kanji. I am having some records with starting Unicode as follows. 6B4C Kanji 歌手生活25周却記念 北島三石1 30A2 Katakana アンテナ I am storing it using sqlite3_bind_text16(). But if I sort the above two the Unicode with 6B4