MySQL :: Re: Illegal mix of collations(utf8_general_ci,IMPLICIT) and (utf8_unicode

Contact MySQL |
Login | Register

The world's most popular open source database

Documentation Downloads MySQL.com

Developer Zone

Section Menu:

New Topic

Re: Illegal mix of collations(utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '='

Posted by: Muhammad Ali
Date: October 10, 2014 07:50AM

Thanks Rick the problem seems to be resolved after creating database like below.

CREATE DATABASE testing
DEFAULT CHARACTER SET = utf8
DEFAULT COLLATE = utf8_general_ci;

Once again I thank you for your support.

Navigate: Previous Message• Next Message

Options: Reply• Quote

Subject

Views

Written By

Posted

Illegal mix of collations(utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '='

35151

Muhammad Ali

October 04, 2014 03:11AM

Re: Illegal mix of collations(utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '='

7191

Muhammad Ali

October 04, 2014 04:37AM

Re: Illegal mix of collations(utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '='

5182

Muhammad Ali

October 06, 2014 05:00AM

Re: Illegal mix of collations(utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '='

6448

Rick James

October 07, 2014 04:20PM

Re: Illegal mix of collations(utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '='

5787

Muhammad Ali

October 10, 2014 07:50AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.