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

[Dean H. <dea...@dl...>]

Jiri Cincura wrote:
> 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)

By the way, while that may be *possible*, I wouldn't ever recommend it. 
You're much better off going with Lucene.NET or something like that and 
allowing for full-text searching.

Dean.