MySQL Bugs: #1102: Data truncated

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:	Windows (Win 2000)
Assigned to:	Venu Anuganti	CPU Architecture:	Any

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.

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.