lt;[EMAIL PROTECTED]>
Subject: Re: [sqlite] text datatype matching functions, binding vs explicit
insert
To: "General Discussion of SQLite Database" <sqlite-users@sqlite.org>
Date: Friday, July 25, 2008, 7:50 PM
On Jul 25, 2008, at 7:44 PM, Harold Wood & Meyuni Gani wro
On Jul 25, 2008, at 7:44 PM, Harold Wood & Meyuni Gani wrote:
> But you can use where 'AA' = upper(fld1) = to get around case issues.
Yes you can. But you need to be aware that doing so will prevent an
index from being used to speed the search. If your table is small it
shouldn't make
Subject: Re: [sqlite] text datatype matching functions, binding vs explicit
insert
On Jul 25, 2008, at 8:50 AM, Chris Holbrook wrote:
> I created a table with four text columns and a blob column, and
> populated it using sqlite3 functions ~prepare, ~bind_text,
> ~bind_blob. Now I
On Jul 25, 2008, at 8:50 AM, Chris Holbrook wrote:
> I created a table with four text columns and a blob column, and
> populated it using sqlite3 functions ~prepare, ~bind_text,
> ~bind_blob. Now I can't query the data using, for example, "where
> app = 'AA'", though "where app like 'AA'"
On Jul 25, 2008, at 8:50 AM, Chris Holbrook wrote:
> I created a table with four text columns and a blob column, and
> populated it using sqlite3 functions ~prepare, ~bind_text,
> ~bind_blob. Now I can't query the data using, for example, "where
> app = 'AA'", though "where app like 'AA'"
I created a table with four text columns and a blob column, and populated it
using sqlite3 functions ~prepare, ~bind_text, ~bind_blob. Now I can't query the
data using, for example, "where app = 'AA'", though "where app like 'AA'"
works! The LENGTH() function returns the number of characters
6 matches
Mail list logo