Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
DBI mysql special characters
I tried, but no change, in fact, when I print the $sql with data in it, it displays in the browser: INSERT INTO `gentblogt` (`title`, `link`, `description`, `date`) VALUES ('Taxidermia', 'http://www.gentblogt.be/2006/09/06/taxidermia', 'De Hongaar György Palfi ...', '2006-09-06 11:01:16') ON... -
DBI mysql special characters
Thanks for your quick reply I use: print "Content-type:text/html\n\n"; would using another content type have a different effect on a DBI action to insert data into a mysql database? I thought the content type only applied to the browser output? Arvid -
DBI mysql special characters
when importing XML RSS into mysql tables, I use a perl script with DBI, XML:Simple, LWP, ... the issue: $description="György"; my $sth = $dbh->prepare( q{ INSERT INTO `testdb` (`description`) VALUES (?) }); $sth->execute($description); after the scripts runs, in mysql table, I always get...
