Re: [Firebird-net-provider] Firebird Unicode Text search

[Jiri C. <di...@ci...>]

On 4/11/08, Teymur Hajiyev <tha...@af...> wrote:
> So, it is not possible to search inside TEXT field???

First, this is question for fb-support list, not for this. Second, why
don't you just try to run command in isql? Third, in FB2+ you can use
txt blobs for some operations, but only items that fit varchar(32k):

create table abc (t blob sub_type text);
insert into abc values ('abcba');
commit;
select * from abc where t like '%c%';

PLAN (ABC NATURAL)

                T
=================
            14a:0
==============================================================================
T:
abcba
==============================================================================

COMMIT;
drop table abc;


-- 
Jiri {x2} Cincura (CTO x2develop.com)
http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com