Problem with apostrophe

Is there any way of having an apostrophe in a data field?
It is a problem because the apostrophe is the same character as the single
quote, so the database gets a parser error when a name such as "O'Brian" 
is entered.

There must be a work-around, but I can not find any solution.

thank you for your help