firebird-net-provider

[Firebird-net-provider] Firebird Unicode Text search

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

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

[Rick R. <Ri...@La...>]

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 !!!