MyODBC masks NULL to "" for mediumtext datatypes in ADO Recordsets(fwd)

Date: Fri, 23 Jan 2004 15:28:31 +0530
From: Nawal Lodha
To: myodbc@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

--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gerberb@zenez.com

--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=gcdmb-bugs@m.gmane.org