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

2008-04-13 Thread Jiri Cincura
On 4/12/08, Dean Harding <[EMAIL PROTECTED]> wrote: > 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. Yes. For '%something%' cannot be used index (only for '%some

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

2008-04-12 Thread Dean Harding
Jiri Cincura wrote: > On 4/11/08, Teymur Hajiyev <[EMAIL PROTECTED]> 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 so

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

2008-04-11 Thread Jiri Cincura
On 4/11/08, Teymur Hajiyev <[EMAIL PROTECTED]> 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 t

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

2008-04-11 Thread Teymur Hajiyev
Sorry, blob type is SYBTYPE 1 (TEXT). Thanks From: Teymur Hajiyev Sent: Friday, April 11, 2008 4:47 PM To: '[EMAIL PROTECTED]'; 'For users and developers of the Firebird .NET providers' Subject: RE: [Firebird-net-provider] Firebird

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

2008-04-11 Thread Teymur Hajiyev
om: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Rick Roen Sent: Friday, April 11, 2008 4:42 PM To: 'For users and developers of the Firebird .NET providers' Subject: Re: [Firebird-net-provider] Firebird Unicode Text search Teymur, I do not have v2 of Firebird, but I

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

2008-04-11 Thread Rick Roen
, 2008 2:31 AM To: firebird-net-provider@lists.sourceforge.net Subject: [Firebird-net-provider] Firebird Unicode Text search Dear All. I use Firebird 2 Server. Below is my table script; CREATE TABLE T3 ( F1 INTEGER, F2 BLOB SUB_TYPE 1 CHARACTER SET UTF8, F3 BLOB); I have

[Firebird-net-provider] Firebird Unicode Text search

2008-04-11 Thread Teymur Hajiyev
Dear All. I use Firebird 2 Server. Below is my table script; CREATE TABLE T3 (   F1 INTEGER,   F2 BLOB SUB_TYPE 1 CHARACTER SET UTF8,   F3 BLOB); I have RTF files and TXT file for each RTF file (in word Save as Plain TXT). The RTF file stores UNICODE TEXT. Using C# I load Text