From: Robert H. Clugston
Date: March 19 1999 11:20pm
Subject: Perl/Mysql problems
List-Archive: http://lists.mysql.com/mysql/652
Message-Id: <001801be725f$0f29a680$10bb53ce@xanadu.csnsys.com>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

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.

============================================================================
Robert H. Clugston
E-mail:robert@stripped
Systems Administrator
Comstock Net, www.comstocknet.com
Phone: (909)877-6407
============================================================================