Show us the code of your sub insert {...}, because that is where the string or number distinction has to be made. Also consider how you will try to insert a string that looks_like_a_number, like "3".

Is there any reason why you aren't using DBI placeholders instead?