> SELECT length(CAST ("Data" AS BLOB)) FROM "message_revision";
What about:
UPDATE "message_revision" SET "Data" = CAST ("Data" AS BLOB);
As a one-time command to correct the table. There is also the option of using
triggers to ensure future "Data" values are kept as BLOB if the INSERT code
cannot be corrected conveniently:
CREATE TRIGGER trigName AFTER INSERT ON "message_revision" WHEN
TYPEOF("Data")!='blob' BEGIN UPDATE "message_revision" SET "Data" = CAST
("Data" AS BLOB) WHERE "message_revision".rowid = NEW.rowid; END;
CREATE TRIGGER trigName2 AFTER UPDATE OF "Data" ON "message_revision" WHEN
TYPEOF("Data")!='blob' BEGIN UPDATE "message_revision" SET "Data" = CAST
("Data" AS BLOB) WHERE "message_revision".rowid = NEW.rowid; END;
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
