@poncho1234 - Thank you for all your efforts Sir :-)
I increased the 50 to 80 in the tables and that has fixed it, probably the simplest way however I have no idea if this was a bad idea especially later on down the line.
I looked around the SQL tables and find CHAR(200) all over, I assume the CHAR(50) could be in error? if not, then I would assume it is 50 for a some reason?
Anyway, for now it seems to all be working.
Kind Regards,
Steven Brewer