Hi, I have had problems reading BLOB fields using MyODBC (I can't see if this is Your way of doing this).
I have solved reading/updating BLOB using the samples from http://www.vbmysql.com/ - http://www.vbmysql.com/articles/visual-basic_mysql/blobaccessvb.html Best regards Peter ----- Original Message ----- From: "Jacob Joseph" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, February 21, 2004 6:32 PM Subject: Problem with Selecting Text and Blob fields When a select query is run on a mysql table with text and blob fields, the text fields return the whole text but the blob fields return only the first 4 bytes of the blob data. I use MySQL 4.0.17 with VB6.0 on Windows 2000. What should I do to retrieve complete data from the blob field? Any help is appreciated and thanks in advance. Jacob Joseph. --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.588 / Virus Database: 372 - Release Date: 2/13/04 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]