Subject | Searching on BLOB data - case sensitive |
---|---|
Author | Wes |
Post date | 2005-06-02T21:47:48Z |
If I submit a SQL statement like this
select
description
from
items
where
description like '%computer%'
Where the field "description" is a BLOB field,
I find that the search is case sensitive.
How can I construct a statement to be
case insensitive. Do I set something in the
FB engine or construct a different SQL
statement?
select
description
from
items
where
description like '%computer%'
Where the field "description" is a BLOB field,
I find that the search is case sensitive.
How can I construct a statement to be
case insensitive. Do I set something in the
FB engine or construct a different SQL
statement?