How to handle ‘ in a name

I am working on a system the will be needing to make database calls using last name as a search parameter. I have been told that it is not possible to handle a ‘ in a name reliably (like O’Sullivan.) Can someone give me coding examples that will work in Java and Javascript? I have done this in other environments by using two ‘, to indicate that the ‘ should be handled as a character and not a delimiter.