I create a Visual C++ COM object that makes use of ADO Recordset for database queries. I need to execute an update query in MySQL. I am using MyODBC-3.51.06 and mysql-4.1.1-alpha. My table has a field with datatype as mediumtext. One record consists the value as "NULL" for this field. But, the ADO returns this value as '' (An Empty String) instead of null during the Select query for the same. The Update populates the where clause of this query from the recordset obtained from the Select query. But the Update fails because of the empty string instead of null for the above field. Please suggest a solution to obtain proper value (for null values) during select for the mediumtext datatypes. Thanks.
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
