Helen, Im sorry..

where you see RTF, please, change by 'RICH Text'
my mistake..:)

i need search in BLOB Field Text that contents RichText. understand ?

im brazilian, so , we using accents characters, that in a richtext it
stores controls characters like '\' e others to create a accent character.

Thanks.

--- In firebird-support@yahoogroups.com, Helen Borrie <helebor@...> wrote:
>
> At 05:49 AM 7/03/2008, you wrote:
> >hi all,
> >
> >is there some UDF to convert a "blob field with rtf content" in a
Plain text field ?
>
> It is a blob filter you would be looking for - a specialised type of
UDF. Firebird doesn't come with any "external" blob filters, although
it uses several itself, internally. (Actually, I'd really like to
start a register of blob filters that people have written and are
willing to share...)
>
> >'cause a need to search with LIKE or CONTAINING in this field
Blob/rtf , using accented characters...
>
> You can store RTF directly in a TEXT blob. RTF - like HTML and XML
- is a text-based format, unlike most word processor files. As long
as you are using that blob field for storing ONLY objects that are
text-based, the normal text features can be used on it directly.
>
> As a note, some people just design blob fields as BINARY, regardless
of content, and poke images, documents, audio files and whatever into
that one field. I strongly recommend against that practice. For my
money, blob fields should be defined for maximum useability and that
means NOT mixing different data formats in the same column. The
engine allows it - even for a TEXT blob - but it has no way of knowing
anything about what kind of data you push into it.
>
> ./heLen
>