eCart 3 and apostrophes

My client with an eCart 3 site is telling me that any apostrophe in a name or an address will cause the order entry process to fail. Apparently the Authorize.Net part succeeds because the CC is charged for the order, but the order does not appear in the database. Any suggestions how I can fix this? I do NOT want to upgrade this site to eCart 5 at this time unless I absolutely have to do so.

The simplest thing to do is strip the apostrophe's from those fields when the post is made. Validate the input and correct as needed! That's never a bad idea at the best of times.

My concern is that this would then interfere with the transaction validation. After all, "O'Leary" is not the same as "O'Leary" or "OLeary".

the issue is occuring when it goes into the database, so strip apostrophes on storing to the database, this way the data sent to Authorize.net will not be effected.

Thanks, Jason. I'll see if I can find that spot. Having saved the item to the database with the apostrophe replaced with an entity, wouldn't I need to replace in the other direction when that user returns for another order?

I'm sorry, i dont quite follow, once the apostrophe has been converted to an entity, it should remain converted.

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?

It would seam to me that the user registration page has code in place to convert the apostrophe.


You should convert the apostrophe character to the html entity in the store order summary behavior or the store order details behavior.

In most cases, these behaviors are on the confirm page.