Errors caused by apostophe

[Ed Richter]

I have an online form, and have run into problems with people who have apostrophe's in their names such as O'Rourke. My form also contains a field for comments and if someone adds a word like I'll, You'll, etc. that will also cause an error upon submission of the form. Actually for some reason I was able to submit the names with the apostrophe in them, but when I do any type query on the name like that, it won't find the record and returns an error.

Is there a simple way around that to allow the apostrophe in various fields? I believe you can do something around the apostrophe with a slash '/' to designate it as a literal character , but in a comment field I'd have no idea where the apostrophe is located to look for it?

 

[Richard Lewis Haggard]

Apostrophe is one of those characters that are not allowed by the HMTL standard. The replacement for it is ' I just ran through something like this in my XML data transfer and had to add encoding and decoding to move into and out of HTML.
========
Richard Lewis Haggard
I have an online form, and have run into problems with people who have apostrophe's in their names such as O'Rourke. My form also contains a field for comments and if someone adds a word like I'll, You'll, etc. that will also cause an error upon submission of the form. Actually for some reason I was able to submit the names with the apostrophe in them, but when I do any type query on the name like that, it won't find the record and returns an error.

Is there a simple way around that to allow the apostrophe in various fields? I believe you can do something around the apostrophe with a slash '/' to designate it as a literal character , but in a comment field I'd have no idea where the apostrophe is located to look for it?