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

Bug On Sql Dump

forums › forums › SQLyog › SQLyog: Bugs / Feature Requests › Bug On Sql Dump

  • This topic is empty.
Viewing 1 reply thread
  • Author
    Posts
    • March 9, 2011 at 4:39 pm #12272
      Lenon
      Member

      1) Right clic on table -> Backup/export-> Backup table as sql dump

      2) Export.

      The sqlyog doesn't convert blob field to utf8.

      Sample:

      On database:

      Column NAME (varchar): Olá

      Column OBS (blog): Olá

      On Sql dump File:

      Column NAME (varchar): Olá (right)

      Column NAME (varchar): Olá (wrong)

      Thank you

      Lenon

    • March 9, 2011 at 4:48 pm #32006
      peterlaursen
      Participant

      Of course it does not 'convert'! It shall not! BLOB data are binary (non-encoded) data. Store you data in a TEXT column if you want encoding to apply! This is not a bug (as you report it). But I am not able to understand how a BLOB in the comes a varchar in the dump.

      Anyway it also looks like you are using a very old SQLyog version. Which one? It looks like a pre-6.0 version (where we did not fully support unicode).

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