Illegal mix of collations (latin1_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation

Problem is related to character sets & collation type of table so

simply change the table charater set & collation type

Use the following command :

alter table <table_name> convert to character set utf8 collate utf8_unicode_ci;

 

or you can chage it manually :

Go to option> and then go to option > Table Options > Collation

Change it to  ” utf8_unicode_ci ”

your problem is solved

.

Add Comment

📖 Read More

• 1. How to update row using joins in MYSQL | to updtae row ,data using joins in sql
• 2. How to import database using command line in MySQL
• 3. How to select database using command line in Mysql
• 4. My Sql Questions And Answers
• 5. Get last conversation in mysql table in facebook style

• 6. Mysql find duplicate records in table
• 7. Sql create table with primary key
• 8. Mysql create table primary key autoincrement example
• 9. Get zip codes in radius Mysql query
• 10. SQL Prevent Duplicate INSERT - MySql