Bug #14715 BINARY column width not making it to mysql
Submitted: 7 Nov 2005 18:59 Modified: 5 Dec 2005 13:44
Reporter: Bobby Beckmann Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Migration Toolkit Severity:S2 (Serious)
Version:1.0.20 OS:Any (All)
Assigned to: CPU Architecture:Any

[7 Nov 2005 18:59] Bobby Beckmann 
Description:
When migrating a MS-Sql BINARY column, the length of the column is not used when creating the column in MySQL, resulting in a binary column of length (1). MS-Sql is reporting the correct length. I think the problem is in the C GRT module, which I do not have source code for.

How to repeat:
see above

Suggested fix:
make sure length is added to BINARY in the create table sql creation
[21 Nov 2005 17:58] Jorge del Conde 
Thanks for your bug report.  I tested this using MSSQL2k and MT 1.0.20
[5 Dec 2005 13:44] Michael G. Zinner 
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