Empty string returned when retrieving text field using ODBC (MFC)

Hello,

I'm trying to get the value of a text field using 
CRecordset::GetFieldValue, but it returns an empty string. Changing the 
type from TEXT to VARCHAR avoids the problem, but I really need to use 
TEXT. Other non-text fields in the record can be retrieved successfully. 
Note that the text value is just a 10-character string.

I've tried changing the flags of the data source in ODBC (allow big 
results sets, limit column size to signed 32-bit range and others I 
don't recall), but it didn't make any difference. Am I doing something 
wrong? Is that supported?

I'm using MySQL 5.1.41 with the MyODBC driver 5.1.6 on Windows 7 x86, 
Visual C++ 2008 SP1. I can provide a slice of the ODBC log if it can be 
useful.

Thanks in advance.
Regards,

Guillermo Miranda.


-- 
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe:    http://lists.mysql.com/[email protected]