Subject RE: [firebird-support] Comparing text blobs within a stored procedure - FB1.5
Author Bob Murdoch
-----Original Message-----
> From:
[] On Behalf Of Helen Borrie
> Sent: Tuesday, September 04, 2007 7:05 PM
> -----------------------------
> Another way this SP would fail at runtime would be if you were
> to pass a string in the NOTE parameter. A text blob and a string
> not interchangeable types. You have to pass a blob here; or,
> alternatively, change that input parameter to a varchar of 32,765 or

> less (for ascii, proportionately less for MBCS). You *can* pass a
> string as input to a text blob in your update statement.

Thanks Helen, that was the problem. I was able to change the type
from blob to varchar and everything works well.

Bob M..