The Only Problem that is evident is the Length Problem, You can check the Max Length befre inserting so that you could od something.

Either Increase the Length, and Make sure that you are not getting Blank spaces... use Trim if 8i Otherwise Use Rtrim(Ltrim(Columnname)) on the Inserted Columns..
Thanks