Note: this question is also posted by me on another website Stack overflow, inorder to get more expert answer and different ways to solve it.

x-links are encouraged like http://stackoverflow.com/questions/27712706/perl-db-insert-with-special-character :) I cross-link cross-postings for maximum collaboration efficiency