Even though it doesn't show anything, there should still be information there (the ASCII character 0 is NULL). This is the easiest way to make sure:
Quote:
|
SELECT LENGTH(profile) FROM character
|
If you want to, you can also add a WHERE or LIMIT clause to limit the results to specific records (good for a larger database), but it should return a length of 19568. If not, it might require adding some info to the first few bytes of data (the checksum field):
Quote:
|
UPDATE character_ SET profile = RPAD('ABCD',19568,CHAR(0)) WHERE LENGTH(profile) != 19568
|
To be honest though, I think the better way to do it would be either to do what cavedude recommended & recreate the characters, etc. However, you could also just inject the known info (race, diety, etc) using
other SQL commands.
Either way, good luck with the project
