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

Sync Produces Errror: Illegal Mix Of Collations For Operation 'con

forums › forums › SQLyog › Sync tools, Migration, Scheduled Backup and Notifications › Sync Produces Errror: Illegal Mix Of Collations For Operation 'con

  • This topic is empty.
Viewing 1 reply thread
  • Author
    Posts
    • December 13, 2011 at 5:37 pm #12535
      Phil Usher
      Member

      Hi,

      I'm evaluating SQLyog as a Sync solution and ran into this error.

      Code:
      Illegal mix of collations for operation 'concat_ws'

      I sucessfully Sync'd three tables (using the default options) but the last table “cases” produces the error.

      Any idea what this error means and how to get Powertools/Database Synchronization Wizard to work?

      Cheers … Phil Usher

    • December 14, 2011 at 6:22 am #32924
      sathish
      Member

      Hello Phil Usher,

      Can you please execute Execute “SHOW CREATE TABLE tablename” for both source and target tables.

      Also, can you tell us:

      Which version of SQLyog you are using(Help->About).

      Which MySQL server you are using(SELECT VERSION()).

      If you don't want to disclose the above information in a public forum, kindly create a support ticket by sending a mail to [email protected].

      Regards,

      Sathish

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