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 0 reply threads
  • Author
    Posts
    • 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 0 reply threads
  • You must be logged in to reply to this topic.