10:55 AM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] SQlite and C works with "like" but not with "="
"Daniel White" <[EMAIL PROTECTED]>
wrote in message news:[EMAIL PROTECTED]
>> Which way is it stored in the database? Show the output of this
>&g
Thanks again Dan and Igor. Since I don't need to write
to the database (only read from it atm), collate binary
will do nicely.
I'll keep an eye on those error messages in future!
Dan
On Sun, 15 Jun 2008 09:13:52 +0100, Dan <[EMAIL PROTECTED]> wrote:
> On Jun 15, 2008, at 8:55 AM, Daniel White
On Jun 15, 2008, at 8:55 AM, Daniel White wrote:
> Cheers both of you, it seems this problem is indeed
> linked with the "no such collation sequence: iunicode"
> error as Dan mentioned.
>
> After some research, I found out that the root of
> the problem is unsurmountable at present. I quote
"Daniel White" <[EMAIL PROTECTED]>
wrote in message news:[EMAIL PROTECTED]
> Oh well, there are one or two 'hacks' around it. The first is
> to use COLLATE BINARY, or COLLATE NOCASE after the SQL query.
> This appears okay on the surface, but probably ignores
> unicode chars or something. It may
Cheers both of you, it seems this problem is indeed
linked with the "no such collation sequence: iunicode"
error as Dan mentioned.
After some research, I found out that the root of
the problem is unsurmountable at present. I quote from:
http://www.mediamonkey.com/forum/viewtopic.php?p=84197
On Jun 14, 2008, at 9:08 PM, Daniel White wrote:
> The course of action I thought you implied was to change
> it from "hexion" to "Hexion", and so I hoped that would
> return the results, but it still doesn't.
>
> "Still" meaning, just like the small 'h', 'H' doesn't
> work either.
>
The answer
> Which way is it stored in the database? Show the output of this
> statement:
>
> SELECT SongTitle FROM songs WHERE SongTitle like 'hexion';
There are 8 records of Hexion in the database, so after a printout
to the console with a carriage return after each value, I basically get:
Hexion
Hexion
"Daniel White" <[EMAIL PROTECTED]>
wrote in message news:[EMAIL PROTECTED]
> The course of action I thought you implied was to change
> it from "hexion" to "Hexion", and so I hoped that would
> return the results, but it still doesn't.
Which way is it stored in the database? Show the output of
The course of action I thought you implied was to change
it from "hexion" to "Hexion", and so I hoped that would
return the results, but it still doesn't.
"Still" meaning, just like the small 'h', 'H' doesn't
work either.
Dan also mentioned the capital letter thing so it
was a reply to him as
"Daniel White" <[EMAIL PROTECTED]>
wrote in message news:[EMAIL PROTECTED]
> Funny you should mention the capital at the start
> to make "Hexion". I thought of that just after I
> posted. But it doesn't solve the problem unfortunately.
> Zero results are still returned.
What do you mean, "still"
Thanks Dan and Igor for clarifying the 5th param.
I'm guessing it's safe to leave it at 0 if I
just use one SQL statement then.
Funny you should mention the capital at the start
to make "Hexion". I thought of that just after I
posted. But it doesn't solve the problem unfortunately.
Zero results
On Jun 14, 2008, at 10:39 AM, Daniel White wrote:
> Hi guys,
>
> My first post to this list, and I'm new to SQL in general too.
>
> Just a couple of questions to start:
>
> ***1:
> In the sqlite3_prepare_v2 function, can someone explain
> to me the 5th parameter better than the site's help can?
"Daniel White" <[EMAIL PROTECTED]>
wrote in message news:[EMAIL PROTECTED]
> My first post to this list, and I'm new to SQL in general too.
>
> Just a couple of questions to start:
>
> ***1:
> In the sqlite3_prepare_v2 function, can someone explain
> to me the 5th parameter better than the site's
Hi guys,
My first post to this list, and I'm new to SQL in general too.
Just a couple of questions to start:
***1:
In the sqlite3_prepare_v2 function, can someone explain
to me the 5th parameter better than the site's help can?
I quote:
/* OUT: Pointer to unused portion of zSql */
I'm a bit
14 matches
Mail list logo
