Weird glitch

hi all. i have a weird glitch happening in a page i have. i have a dropdown list on a database record update page. For some unknown reason, when a user selects an option that contains a double quote, when the user presses the Update button, a null value is entered for that field. the weird thing is the rest of the form works perfectly without errors being returned. if the user selects a value without any quotes in it, all works perfectly. it's only quotes that result in a null value being saved. And please dont say "just don't use quotes", because the field is referring to inches and the customer needs to use double quotes as short form for inches, and have 100's of records with it already. so i need to find a database solution unfortunately.

what front end are you using? php has mysql_real_escape_string which if you are using that app you should be using.

the problem isn't your database so much as how you deal with the input on the front end.

as such this isn't a database question but belongs in the forum for whatever application you are using to process the form, php, perl, asp whatever.

the weird thing is, I AM using mysql_real_escape_string though, and the error doesn't happen in any of the 12 other dropdowns i have on the page, some of which have the exact same values and should behave the same way. i have this :