#1
  1. A Change of Season
    Devshed Frequenter (2500 - 2999 posts)

    Join Date
    Mar 2004
    Location
    Next Door
    Posts
    2,672
    Rep Power
    171

    � in the database!


    Hello, trying to clean the database from �s.
    SELECT *
    FROM `packages`
    WHERE `description` LIKE '%�%'
    LIMIT 0 , 30
    #1267 - Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation 'like'
    What to do?
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Apr 2009
    Posts
    157
    Rep Power
    89
    Write a php script to do it. BTW there are at least 4 Microsoft quotes you need to filter for.
  4. #3
  5. A Change of Season
    Devshed Frequenter (2500 - 2999 posts)

    Join Date
    Mar 2004
    Location
    Next Door
    Posts
    2,672
    Rep Power
    171
    Originally Posted by TASB
    Write a php script to do it. BTW there are at least 4 Microsoft quotes you need to filter for.
    Hello thanks.

    I know these 2:

    Can you please tell me the rest?

    Thanks
  6. #4
  7. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Apr 2009
    Posts
    157
    Rep Power
    89
    Yep.

    The reverse of the two.

IMN logo majestic logo threadwatch logo seochat tools logo