OK, now with everything in place, making SD's edit to bbcode.inc.php allows new posts to go in properly. So I think that is now set.
So it's a multi-step process. Get the table into UTF8. Copy over the rows to fill in the missing data. Then alter the code so data going forward is inserted OK.