Bug #52007 MySQL ODBC connector returns the wrong datatype for unsigned integers
Submitted: 12 Mar 2010 17:36 Modified: 22 Mar 2010 13:22
Reporter: Ed Macauley Email Updates:
Status: Not a Bug Impact on me:
None 
Category:Connector / ODBC Severity:S2 (Serious)
Version:5.1.6 and 3.51.27 OS:Any (Windows Xp, Centos, Redhat and others)
Assigned to: CPU Architecture:Any
Tags: ODBC Connector, UNSIGNED

File: Maximum allowed size is 50MB.
Description:
Privacy:

If the data you need to attach is more than 50MB, you should create a compressed archive of the data, split it to 50MB chunks, and upload each of them as a separate attachment.

To split a large file:

[12 Mar 2010 17:38] Ed Macauley
C# example, using 6.2.2 of the .NET provider

Attachment: Program.cs (text/plain), 1.83 KiB.

[12 Mar 2010 17:39] Ed Macauley
sample schema

Attachment: test-schema.sql (application/octet-stream, text), 2.04 KiB.

[12 Mar 2010 17:42] Ed Macauley
unixODBC trace with a CAST to UNSIGNED, this does not truncate data

Attachment: trace with cast.log (application/octet-stream, text), 7.06 KiB.

[12 Mar 2010 17:43] Ed Macauley
unixODBC trace with no CAST, data is truncated

Attachment: trace no cast.log (application/octet-stream, text), 7.26 KiB.