Perl/Mysql problems - Robert H. Clugston - com.mysql.lists.mysql

3 messages in com.mysql.lists.mysqlPerl/Mysql problems

From	Sent On	Attachments
Robert H. Clugston	19 Mar 1999 15:19
Daniel Koch	19 Mar 1999 15:22
Faisal Nasim	19 Mar 1999 20:56

Subject:	Perl/Mysql problems
From:	Robert H. Clugston (rob...@csnsys.com)
Date:	03/19/1999 03:19:59 PM
List:	com.mysql.lists.mysql

Dear List, I'm using Perl to write the my database. To avoid problems when inserting rows into my table I use the perl \Q\E method to escape all characters. Below is my query:

$query = 'INSERT into messages VALUES("' . "\Q$name\E" . '", "' . "\Q$email\E" . '", "' . "\Q$d ate\E" . '", "' . "\Q$subject\E" . '", "' . "\Q$message\E" . '", "' . "\Q$id\E" . '")';

Ever since updating to Debian 2.1 when ever I insert a "?" a null character is inserted in its place. In Debian 2.1 I believe the Mysql server version is 3.21.33b.