Subject | How to search or convert a BLOB/RICHTEXT field to Text plain |
---|---|
Author | rperalva |
Post date | 2008-03-09T22:02:48Z |
Somebody could help me about this ? (please read text below)
Thanks.
Thanks.
--- In firebird-support@yahoogroups.com, "rperalva" <rperalva@...> wrote:
>
> 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
> >
>