A new toon was added to my guild and this toon has a name that includes a special character (Ássassin). When I try to update the roster I get the following database error:

Code: Select all

1267: Illegal mix of collations (utf8_general_ci,IMPLICIT) and (latin1_swedish_ci,COERCIBLE) for operation '='
SQL:
SELECT `member_id` FROM `roster_members` WHERE `name` = 'Ássassin'
File: update_trigger_lib.php
Line: 41

I am assuming this error is occuring because of the first character (Á) of this toon's name. Does anyone know how I can work around this issue (other than removing the offending toon from the guild)?

Make sure all your tables in your database are the same collation