|Subject||Re: [IBO] FTS Bugs?|
> Sorry, John, I missed the possibility that your problem was comingHelen,
> from having sub_type 0 blobs. Exactly the same problem hit me during
> testing and I had to rebuild my test database, re-storing sub_type 0
> blobs with sub_type 1. I *thought* I had documented it, too, so I'll
> go back and check up on that.
I believe it was a sub_type 1 blob that he was using. It was me that
suggested the trigger code built for that column was inappropriate for
a blob (comparing the blob column to a blank string).
Am I wrong? Is firebird now able to automatically translate text
blobs inside trigger/procedure languages to allow direct text
assignments and comparisons??
Geoff Worboys - TeamIBO