firebird-net-provider

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

[Teymur H. <tha...@af...>]

Thank you for your reply.

I mean, my blob type is SYBTYPE 2 (TEXT). I want it "for Comments" field. Pls, read here: http://www.ibphoenix.com/main.nfs?page=ibp_blobs

 

So, it is not possible to search inside TEXT field???

 

Thanks in advance.

 

________________________________

From: fir...@li... [mailto:fir...@li...] 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 did not think it was possible to search inside a BLOB field.  You might confirm this in a FB newsgroup or in the FB docs.

 

Regards,

 

Rick

 

From: fir...@li... [mailto:fir...@li...] On Behalf Of Teymur Hajiyev
Sent: Friday, April 11, 2008 2:31 AM
To: fir...@li...
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 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 File to F2 field and RTF file to F3 field.

 

Now, I want to run text search:

 

SELECT     F1

FROM         T3

WHERE     (F2 LIKE '%Республикасы%') 

 

- it returns no record.

 

But in reality there is. As I save the F2 field of that record to file, everything is there...

 

Could you pls let me know what is problem?

Thanks in advance.

 

Teymur Hajiyev

 

________________________________

 

Privacy Declaration: This e-mail and its attachments contain confidential information from "Azerfon LLC" ,which is intended
only for the person or entity whose address is listed above. Any use of the information contained herein in any way
(including, but not limited to, total or partial disclosure, reproduction, or dissemination) by persons other than
the intended recipient(s) is prohibited. If you receive this e-mail in error, please notify the sender by phone or
email immediately and delete it!

 

Please use @afon.az domain instead of @azerfon.az for emails you are sending to AZERFON LLC !!!

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

[Teymur H. <tha...@af...>]

Sorry, blob type is SYBTYPE 1 (TEXT).

 

Thanks

 

________________________________

From: Teymur Hajiyev 
Sent: Friday, April 11, 2008 4:47 PM
To: 'Ri...@La...'; 'For users and developers of the Firebird .NET providers'
Subject: RE: [Firebird-net-provider] Firebird Unicode Text search

 

Thank you for your reply.

I mean, my blob type is SYBTYPE 2 (TEXT). I want it "for Comments" field. Pls, read here: http://www.ibphoenix.com/main.nfs?page=ibp_blobs

 

So, it is not possible to search inside TEXT field???

 

Thanks in advance.

 

________________________________

From: fir...@li... [mailto:fir...@li...] 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 did not think it was possible to search inside a BLOB field.  You might confirm this in a FB newsgroup or in the FB docs.

 

Regards,

 

Rick

 

From: fir...@li... [mailto:fir...@li...] On Behalf Of Teymur Hajiyev
Sent: Friday, April 11, 2008 2:31 AM
To: fir...@li...
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 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 File to F2 field and RTF file to F3 field.

 

Now, I want to run text search:

 

SELECT     F1

FROM         T3

WHERE     (F2 LIKE '%Республикасы%') 

 

- it returns no record.

 

But in reality there is. As I save the F2 field of that record to file, everything is there...

 

Could you pls let me know what is problem?

Thanks in advance.

 

Teymur Hajiyev

 

________________________________

 

Privacy Declaration: This e-mail and its attachments contain confidential information from "Azerfon LLC" ,which is intended
only for the person or entity whose address is listed above. Any use of the information contained herein in any way
(including, but not limited to, total or partial disclosure, reproduction, or dissemination) by persons other than
the intended recipient(s) is prohibited. If you receive this e-mail in error, please notify the sender by phone or
email immediately and delete it!

 

Please use @afon.az domain instead of @azerfon.az for emails you are sending to AZERFON LLC !!!

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

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.

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

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

On 4/12/08, Dean Harding <dea...@dl...> 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 '%something' or
starting with), so it's very slow on big table.

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