MySQL Bugs: #30657: Migration Toolkit incorrectly converts TEXT column to VARCHAR(16) on Sybase

Bug #30657	Migration Toolkit incorrectly converts TEXT column to VARCHAR(16) on Sybase
Submitted:	28 Aug 2007 0:20	Modified:	3 Sep 2007 16:48
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

Description:
It seems MT is unable to correctly convert a Sybase TEXT column, so it defaults to the default VARCHAR(16) which is not adequate

How to repeat:
Sybase Table Definition

CREATE TABLE dbo.table_name
(
    field1 varchar(50) NOT NULL,
    field2   varchar(60) NULL,
    field3  text        NOT NULL
)

Ultimately the error is that it is truncating data because it does not fit in varchar(16)

Suggested fix:
N/A

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