Release Notes

Excel2MySQL 2.5.9

This version includes the following improvements and fixes.

  • Added MEDIUMTEXT when cell > 21845 (MySQL unicode varchar limit)
    MEDIUMTEXT is sufficient to handle to largest possible Excel Cell note.

    MySQL has a maximum character limit of 65535 characters for VARCHAR and TEXT fields.
    However, if you use a multi-byte unicode character set (i.e. Japanese, Arabic... etc.)
    then the max character limit is 21845.

    Bug discovered by John P.

    MySQL Field Type UTF-8 Limit (bytes) Unicode Limit (bytes)
    VARCHAR 65535 21845
    TEXT 65535 21845
    MEDIUMTEXT 16777215 5592405
    LONGTEXT 4294967295 1431655765
    Excel Cell Max Size