Export Truncates Cell Contents

[minkisi]

I exported the results of a query to Excel (.xls) and the contents of a cell defined as varchar(200) were truncated in the output.

Is this a bug or is there a place to set the output field length?

Thanks,

Marilyn

[peterlaursen]

You cannot export to .xls with SQLyog. The SQLyog EXCEL export uses the Excel 2003/2007 XML-based format. You can open it in an editor (like Notepad) and see if data were truncated during export or if is Excel that truncates data during import.

Now

1) attach a sample exported file

2) generate a table using the same query (“create table tablename select …”) and dump that table and attach here.

(and please zip files)

[minkisi]

I exported the rows again, this time to the EXCEL .xml format. I can see in the editor that the fields are truncated here, so it is happening in the SQLyog export. Is there a limitation on the field length when exporting from SQLyog?

Thanks,

Marilyn

[peterlaursen]

The default setting is 50 characters. Did you change it?

[Author]

Posts