I'm a little confused here. My client is telling me that when an order is placed from someone with an apostrophe in their name or their address, that the order never appears in the database, although the card and transaction is approved by AuthNet and the client is debited for the order.
When I search the users table for users who have registered where the last name or the address fields contain an apostrophe character, I can find a dozen or so instances. When I search the orders table for such matches, there are zero instances, so what she is telling me seems correct. Why is this data being entered without problems into the users table, but not into the orders table?
Presumably, switching the apostrophe with the ' entity would allow that data to be entered into the orders table without issue, but I cannot find a convenient place to do that after the transaction has been approved in the confirm page and before the data is entered in the checkout success page. Any suggestions?
