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 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: [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 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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Teymur Hajiyev
Sent: Friday, April 11, 2008 2:31 AM
To: [email protected]
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 !!!
-------------------------------------------------------------------------
This SF.net email is sponsored by the 2008 JavaOne(SM) Conference
Don't miss this year's exciting event. There's still time to save $100.
Use priority code J8TL2D2.
http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone
_______________________________________________
Firebird-net-provider mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
