Bug #11100 | Add transformation vrom VARCHAR < 65536 to TEXT | ||
---|---|---|---|
Submitted: | 4 Jun 2005 17:48 | Modified: | 11 Feb 2009 13:15 |
Reporter: | Peter Fassev | Email Updates: | |
Status: | Not a Bug | Impact on me: | |
Category: | MySQL Migration Toolkit | Severity: | S4 (Feature request) |
Version: | OS: | Any | |
Assigned to: | CPU Architecture: | Any |
[4 Jun 2005 17:48]
Peter Fassev
[11 Feb 2009 13:15]
Susanne Ebrecht
Many thanks for pointing this out. VARCHAR(254) => VARACHAR(254) VARCHAR(4000) => Hint that you should change manually => TEXT => TEXT VARCHAR(65500) => Hint that you should change manually => TEXT => MEDIUMTEXT Consider here that 65500 is numbers of characters and not bytes. Consider that utf8 could have up to 3 bytes per character. According to documentation: http://dev.mysql.com/doc/refman/5.1/en/storage-requirements.html Text is given there in Bytes. 65000 characters could be 3 times more then 65500 so convertion to Mediumtext is correct.