#1
  1. Plays with fire
    Devshed Novice (500 - 999 posts)

    Join Date
    Aug 2003
    Location
    Barsoom
    Posts
    942
    Rep Power
    96

    Illegal mix of collations


    Hi--

    Running a query to clean up some improperly formatted characters:

    Code:
    UPDATE jobs SET title = REPLACE(title, '᾿', '\"');
    I get this error:

    Code:
    #1270 - Illegal mix of collations (latin1_swedish_ci,IMPLICIT), (utf8_general_ci,COERCIBLE), (utf8_general_ci,COERCIBLE) for operation 'replace'
    After some browsing, people are suggesting to alter the table's default charset to UTF8. I've tried that and it doesn't work.

    If I change the fields collation to UTF8_general_ci all is well.

    I'm wondering if this is a good solution and if it's okay to change the collation of all my fields to this.

    TIA!
    Last edited by Frank Grimes; August 14th, 2013 at 09:32 AM.
    “Be ashamed to die until you have won some victory for humanity.” -- Horace Mann

    "...all men are created equal." -- US Declaration of Independence

IMN logo majestic logo threadwatch logo seochat tools logo