So far, you've given us one "No no no ... oops" after several go-arounds. I'm growing weary of trying to pry information out of you.

Your assignment now is to provide a small code fragment that demonstrates this type of truncation. By "demonstrate" I mean insert data into the database, then select it back out, verifying that what came out isn't what went it.

I still suspect that all of your problems are downstream, after you pulled data that contains quotes out of the database, and when you try to construct HTML from it. When you view the data, you're seeing what you expect, because you haven't done the necessary entity encoding.

Please prove me wrong by posting a code snippet.

 $ins = "INSERT INTO `items` (`category`, `itemid`, `description`, `lo
+ngdescription`, `size`, `o1n`, `o1o`, `o2n`, `o2o`, `o3n`, `o3o`, `c1
+n`, `c1v`, `c2n`, `c2v`, `c3n`, `c3v`, `price`, `small`, `large`)
        VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, 
+?, ?)";

 $sth = $dbh->prepare("$ins") or die $dbh->errstr;
 $sth->execute(map(scalar param($_), qw(cat itemid des longdes size o1
+n o1o o2n o2o o3n o3o c1n c1v c2n c2v c3n c3v)),$price,$small,$large)
+ or die $dbh->errstr;
[download]