It would seem that *something* is calling UpdateText-although I am not doing it directly. I am only using ANSI sql.

It is curious why i cannot get this test/example (below) to fail:

If I have a table with (mrID, mrDESCRIPTION) which is an (int, text)--

I can have $data be an empty string, or hava a value.

eval
{
 $dbh->do("DELETE FROM MASTER1 WHERE mrID=999");
 $dbh->do("INSERT INTO MASTER1 (mrID) VALUES (999)");
 $sql = "UPDATE MASTER1 SET mrDESCRIPTION=? WHERE mrID=999";
 $sth = $dbh->prepare($sql);
 $sth->bind_param(1, $data, DBI::SQL_LONGVARCHAR); 
 $sth->execute();        
 $dbh->commit();
};
[download]

This is a simplified version of what IS apparently failing for the user... hmm. And thanks for the example!

Matt