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

Hi,

Did you try "handle binary as char" option?

What's a charset of your field? do you set charset in connection string/dsn?

And yes, odbc log would be useful. But the better place for it probably 
a bug report would be, not this maillist.

Regards,

Lawrin Novitsky

Guillermo Miranda Álamo wrote:
> 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]