Date: Fri, 23 Jan 2004 15:28:31 +0530 From: Nawal Lodha <n.lo...@zensar.com> To: myo...@lists.mysql.com Subject: MyODBC masks NULL to '' for mediumtext datatypes in ADO Recordsets

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 MySQL ODBC
Driver-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 ODBC Driver 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 get the appropriate value from the ADO.

Thanks. Nawal Lodha