I'm not sure if this will actually work, but you might want to try inserting data without any values into the blobs (all binary 0's). I would imagine the easiest way to do this would be the following:
Quote:
|
UPDATE character_ SET profile = RPAD('',19568,CHAR(0)) WHERE LENGTH(profile) != 19568
|
To clarify, that's 2 apostrophies inside the RPAD. This
should create a blob 19568 characters long with all zeroed information wherever the blob isn't the appropriate length. However, I'm not sure if the server will be able to do anything with it, other than maybe inserting the character name, because it is stored in the name field also.