Bug #30325 Migration Toolkit should convert Sybase TINYINT to MySQL UNSIGNED TINYINT
Submitted: 9 Aug 2007 0:03 Modified: 3 Sep 2007 13:01
Reporter: Trent Lloyd Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Migration Toolkit Severity:S2 (Serious)
Version: OS:Any
Assigned to: CPU Architecture:Any

[9 Aug 2007 0:03] Trent Lloyd 
Description:
Currently, when converting from Sybase to MySQL with the Migration Toolkit, a TINYINT is converted to a TINYINT (SIGNED)

It seems that in sybase, a TINYINT (and only a TINYINT, not other INTs) is actually unsigned

This happened in a conversion, and also this page seems to indicate so:
http://manuals.sybase.com/onlinebooks/group-iq/iqg1250e/iqref/@Generic__BookTextView/23134...

How to repeat:
N/A

Suggested fix:
Convert TINYINT to TINYINT UNSIGNED
[9 Aug 2007 0:13] Trent Lloyd 
It was suggested adding

grtV.insert(dt.flags, "UNSIGNED")

to the TINYINT section of the sybase.lua file might do the trick here
[9 Aug 2007 3:47] Valeriy Kravchuk 
Yes, TINYINT in Sybase is 8-bit integer ranges from 0 to 255. See also:

http://www.indiana.edu/~dss/Services/DataWarehouse/Oracle/Sybase/conversion.html
http://www.rocket99.com/sybase/sybase125.html
...

So, this is a bug.
[3 Sep 2007 13:01] 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 bug fix. More information about accessing the source trees is available at

    http://dev.mysql.com/doc/en/installing-source.html