..so to continue, AndMetal's SQL for modifying BLOBS in profile can be done according to
Code:
UPDATE character_ SET profile = INSERT
((SELECT profile FROM (SELECT * FROM character_) AS x WHERE id = 748),
(4720+1),4,RPAD(CHAR(100),4,CHAR(0))) WHERE id = 748;
from AndMetal's message quoted--
"In theory, you can change 4720 to any field # in the profile blob & the 100 to whatever numeric value you want it set to. You would then need to change the 4's to correspond with however many characters the data takes up (32-bit integers are 4, for example), otherwise the blob will become corrupt (too many/too few characters)."
I think you can expand on this..
GeorgeS
Threaded Mode
