The GUI is probably doing the data conversion for you. I would not assume there is any corruption or that there is anything wrong with the database.

Can you post your insert statement and errors?

>>Or FORCE an insert by performing some type of casting/datatype-change

of the source value?

Yes, go this route although I wouldn't call it forcing the insert, just fixing the insert.