Jump to content


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

  • Please log in to reply
1 reply to this topic

#1 Phil Usher

Phil Usher


  • Members
  • Pip
  • 1 posts

Posted 13 December 2011 - 05:37 PM


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

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

#2 sathish


    Advanced Member

  • Members
  • PipPipPip
  • 334 posts
  • Gender:Male

Posted 14 December 2011 - 06:22 AM

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 support@webyog.com.


0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users