Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Export To Excel Xml Generates Bad Data

forums › forums › SQLyog › SQLyog: Bugs / Feature Requests › Export To Excel Xml Generates Bad Data

  • This topic is empty.
Viewing 1 reply thread
  • Author
    Posts
    • January 19, 2010 at 6:04 am #11837
      magnusdopus
      Member

      I have a set of results that are generated via a GROUP_CONCAT operator. The result set is over 2000 records. When I export this Excel XML, the resulting XML has several cells where the correct value has been replaced with 'Binary/Image'. This only applies to the columns that were built using the GROUP_CONCAT operator. Also, the error does not show on every row. There doesn't appear to be a clear pattern why this occurs. The data shows up clearly in the SQLYOG grid. And it exports correctly in SQL.

    • January 19, 2010 at 7:06 am #30350
      peterlaursen
      Participant

      hmmm .. I am not sure how MS Office programs identifies BINARY data.  MySQL will (according to C-standards) identify data having the NULL byte ('') as binary data. This could both be an issue/incompability with Excel vs. MySQL or something we do wrong when exporting.

      Please create a silly example for reproducing this 

      1) a table with a few data. Dump the table and attach here (or just paste if it is very small).

      2) Also provide such query using GROUP_CONCAT where result set exported to Excel shows up like this

  • Author
    Posts
Viewing 1 reply thread
  • You must be logged in to reply to this topic.