Bug #69779 | Export fails for Excel files containing > 4000 characters of text per cell | ||
---|---|---|---|
Submitted: | 18 Jul 2013 13:01 | Modified: | 26 Sep 2013 9:34 |
Reporter: | Rob Sherratt | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL for Windows: MySQL for Excel | Severity: | S2 (Serious) |
Version: | 5.6 | OS: | Windows (Excel 2013) |
Assigned to: | CPU Architecture: | Any | |
Tags: | BLOB, Excel, export, fail, text |
[18 Jul 2013 13:01]
Rob Sherratt
[19 Jul 2013 10:14]
Sveta Smirnova
Thank you for the report. Verified as described.
[25 Sep 2013 21:22]
Philip Olson
Fixed as of MySQL for Excel 1.1.2, and here's the changelog entry: When "Export Data" from Microsoft Excel was used to create a MySQL table, and any of the Excel spreadsheet cells contained over 4,000 characters of text, the export failed with the following message: "MySQL Error 1118: Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs" Under this condition, the data type is now changed to TEXT instead of VARCHAR(65535). Thank you for the bug report.
[26 Sep 2013 9:27]
Rob Sherratt
Thank you very much for fixing this problem!
[26 Sep 2013 9:34]
Rob Sherratt
Has this "solution" been tested for Import as well as Export from Excel files? In other words, thanks to this bug fix, we can now "Export" because large fields >4000 characters are exported as type "Text" to the MySQL data table. What happens when the same data is imported again from the MySQL data table to the Excel file with data types of "Text" containing >4000 characters?