| Subject | Re: [firebird-support] How to search or convert a BLOB/RTF field |
|---|---|
| Author | Helen Borrie |
| Post date | 2008-03-06T21:52:42Z |
At 05:49 AM 7/03/2008, you wrote:
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
>hi all,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...)
>
>is there some UDF to convert a "blob field with rtf content" in a Plain text field ?
>'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