Is all that extra junk necessary?
IOW, does the EMU just read up to the null terminator, or is it encoding something in the rest of the BLOB? I looks like junk, but I guess the EMU may need to know the processor architecture of the person who originally put in the item...
It seems like
INSERT INTO items (id, raw_data) VALUES (1001, 'Cloth Cap\0');
would work, but I don't know for sure. If all it needs is the name, though, why not just use a varchar?
|