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

[28 Aug 2007 0:20] Trent Lloyd 
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
[3 Sep 2007 16:48] 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

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.039 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.