Bug #1102 Data truncated
Submitted: 20 Aug 2003 0:19 Modified: 6 Oct 2003 2:40
Reporter: Ming Huang Email Updates:
Status: Closed Impact on me:
None 
Category:Connector / ODBC Severity:S1 (Critical)
Version:latest OS:Microsoft Windows (Win 2000)
Assigned to: Bugs System CPU Architecture:Any

[20 Aug 2003 0:19] Ming Huang
Description:
ODBC driver reports wrong column data size for mediumblob columns.  It reports 65535 to MS CRecordset even the blob column is mediumblob columns.  CRecordset binds a 65535 bytes CByteArray to the mediumblob field to cause data truncated error.

How to repeat:
Create a table with mediumblob column then try to insert a data field with size greater than 65535 bytes to the table.  A CDBException will throw with "Data truncated" error.

Suggested fix:
Find in your ODBC drive source where 65535 or related constant is used, specially in function SQLDescribtCol function, to see it used to report precision for mediumblob column or not.  Fix it please.
[6 Oct 2003 2:40] Venu Anuganti
Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.

If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information 
about accessing the source trees is available at
    http://www.mysql.com/doc/en/Installing_source_tree.html

Thanks for the report, and yes, this is already addressed in 3.51.07.