MySQL Forums
Forum List  »  MySQL for Excel

MySQL for Excel Plug-in - needs TEXT and BLOB datatype capability
Posted by: Rob Sherratt
Date: July 18, 2013 05:33AM

When using "Export Data" from Excel to create a MySQL table, if the user's excel spreadsheet cells contain the Excel max cell size of 32767 characters of text, the export fails 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"

When there is a lot of text in a cell, the exporter sets the corresponding column datatype to VARCHAR(65535). Of course this is a "bug" - because when exporting, the above error message will always happen and the export fails.

The MySQL for Excel plug-in needs to provide the capability to set the datataype of the columns to TEXT or BLOB instead of VARCHAR(65535), but there is no datatype TEXT or BLOB defined in the plug-in. So at this point the Excel file can not be processed. Please could capability for the TEXT or BLOB datatypes be added?

Also when using the "Import MySQL Data", please can the Excel Plug-in be modified so that TEXT and BLOB datatypes in the MySQL Table are read into Excel subject to Excel's cell size max of 32767 characters?

Thanks,
Rob

Options: ReplyQuote


Subject
Views
Written By
Posted
MySQL for Excel Plug-in - needs TEXT and BLOB datatype capability
4448
July 18, 2013 05:33AM


Sorry, you can't reply to this topic. It has been closed.

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.