I am newbe for this forum, Here is my issue:
Caused by: java.sql.SQLException: Illegal mix of collations (latin1_swedish_ci,I
I am getting above error. I have checked collation in my.cnf file and got to know that it is utf8.
When I checked table collation by using show table status like ‘ xxx’; command got to know that it is having latin1_swedish_ci, and checked other tables are also have same collation.
Where as when I checked different database tables those are having utf8 collation.
By observing all results I understood that the database’s (I am having issue) collation has changed. I am thinking to change the collation by using alter command.
I am I right here? This is production database so I need to be 200 % sure before going to deploy. Please any one suggest any thing over looked here or any thing needs to checked.
Any help would be greatly Appreciated !!! Thanks in advance.
- The topic ‘Mysql Collation issue’ is closed to new replies.