I have the need to move fields of type TEXT (a simple blob type) into either a BLOB or CLOB field via sql.
Is there any way to do this within sql? I get a
"617: A blob data type must be supplied within this context."
error when I try to copy via a selection using a statement like this:
update blobtable set blobfield = (select textfield from texttable where id = 1) where id = 1
If I alter a table and change a TEXT field to a CLOB it maintains the data so I don't quite see why I shouldn't be able to copy between the types...
Is there any way to do this within sql? I get a
"617: A blob data type must be supplied within this context."
error when I try to copy via a selection using a statement like this:
update blobtable set blobfield = (select textfield from texttable where id = 1) where id = 1
If I alter a table and change a TEXT field to a CLOB it maintains the data so I don't quite see why I shouldn't be able to copy between the types...