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

Change All Entities Into Utf8

forums › forums › SQLyog › Using SQLyog › Change All Entities Into Utf8

  • This topic is empty.
Viewing 3 reply threads
  • Author
    Posts
    • October 25, 2011 at 6:23 pm #12483
      Pentium10
      Member

      Is there a way I can use SQLYog to change all my databases/tables/columns into UTF8 when they are mixed of latin and utf?

    • October 25, 2011 at 9:31 pm #32743
      peterlaursen
      Participant

      Well ..

      You can do from the table (context) menu .. ALTER TABLE. You may change the charset for individual columns (clcik the option to 'show language options') or from ALTER TABLE .. advanced if you want to change the default charset of a table (but changing the defaut charset for a table- or a database for that sake – does not change the encoding of existing columns).

      Please also read this FAQ: http://webyog.com/faq/content/34/152/en/my-special-characters-display-as-_noisy_-latin-characters-in-sqlyog.html

    • October 26, 2011 at 4:34 am #32744
      Pentium10
      Member
      'peterlaursen' wrote:

      Well ..

      You can do from the table (context) menu .. ALTER TABLE. You may change the charset for individual columns (clcik the option to 'show language options') or from ALTER TABLE .. advanced if you want to change the default charset of a table (but changing the defaut charset for a table- or a database for that sake – does not change the encoding of existing columns).

      Please also read this FAQ: http://webyog.com/faq/content/34/152/en/my-special

      -characters-display-as-_noisy_-latin-characters-in-sqlyog.html

      i was looking for a mass operation.

    • October 26, 2011 at 7:37 am #32745
      peterlaursen
      Participant

      well .. here we cannot help.

  • Author
    Posts
Viewing 3 reply threads
  • You must be logged in to reply to this topic.