Being in Italy, we use apostrophes in our fields constantly! MySQL itself has no problems with them at all.
As you say, you're using ASP as your front end, and standard SQL statements to add, edit and delete records. For ASP I'm not sure, but in our PHP code it works to simply add a backslash before each apostrophe before using the string in the database. For SQL you may find that just using double quotes for all strings is sufficient to recognize the apostrophe as a regular character. ____________________________________________ Steve Rapaport CTO, A-Tono Via Amedei, 15 - Milano 20123 Cel.: +39 348 6431573 Fax : +1 617 687 0415 ] -----Original Message----- ] From: Loretta [mailto:[EMAIL PROTECTED]] ] Sent: Wednesday, March 27, 2002 6:54 AM ] To: [EMAIL PROTECTED] ] Subject: ASP and MySQL ] ] ] I am having a problem inserting names with apostrophes into the MySQL ] database. I am using ASP as my front end with standard SQL statements to ] add, edit and delete records. I read the section in the manual on escape ] characters and have played around with many different variations trying to ] get it to work with absolutely no luck. ] ] The statement I am currently using looks like this: ] lname = Replace(Request.Form("lname"),"'","''") ] ] I have tried using the backslash character and several variations of ] different numbers of apostrophes. ] ] I would appreciate any help as this is the last problem to be ] solved before ] the database is functional. The rest of the debugging has been completed. ] ] Thank-you in advance, ] Loretta ] ] ] --------------------------------------------------------------------- ] Before posting, please check: ] http://www.mysql.com/manual.php (the manual) ] http://lists.mysql.com/ (the list archive) ] ] To request this thread, e-mail <[EMAIL PROTECTED]> ] To unsubscribe, e-mail ] <[EMAIL PROTECTED]> ] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php ] --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
