List:General Discussion« Previous MessageNext Message »
From:Robert H. Clugston Date:March 19 1999 11:20pm
Subject:Perl/Mysql problems
View as plain text  
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
============================================================================

Thread
Perl/Mysql problemsRobert H. Clugston20 Mar
  • Re: Perl/Mysql problemsDaniel Koch20 Mar
Re: Perl/Mysql problemsFaisal Nasim20 Mar