> I have a table with two blob columns and was wondering how I can go
> about clearing the blob column's contents?
>
> When trying: UPDATE MyTable SET blob1 = null, blob2 = null
>
> I get the error: Overflow occurred during data type conversion.
> conversion error from string "BLOB"

Actually, this should work fine as far as I can tell.

Do you have some triggers with regard to these columns perhaps?

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server
Upscene Productions
http://www.upscene.com