"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
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*
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
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
"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
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(
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
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: [
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
"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
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
11 matches
Mail list logo