Bill: What about the DBI's quote() method... isn't this what its for? http://www.mysql.com/doc/P/e/Perl_DBI_Class.html
Keith -----Original Message----- From: Bill Platt [mailto:[EMAIL PROTECTED]] Sent: Saturday, March 02, 2002 2:25 AM To: [EMAIL PROTECTED] Subject: Quotation Marks in Mysql fields I have what may seem a silly question on this list. As I am fairly new to mysql, I am not sure what the answer might be. I have noticed my software generating errors everytime I try to place the single or double quote into the table columns. At this time, I have scripted my perl to turn these quotation marks into nulls to get the software to quit triggering the error. Now, my question is this. How do I get the database to accept the quotation marks and apostrophes?? The kind of data I am entering into the tables is better with these items left in rather than left out. Thanks, Bill Platt --------------------------------------------------------------------- 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