Special characters in toon names

CharacterProfiler.lua file uploading issues

Special characters in toon names

Postby zerog » Fri Oct 06, 2006 7:52 pm

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)?
zerog
WR.net Apprentice
WR.net Apprentice
 
Posts: 1
Joined: Wed Aug 02, 2006 4:01 am

Special characters in toon names

Postby zanix » Sat Oct 07, 2006 2:08 am

Make sure all your tables in your database are the same collation
Read the Forum Rules, the WiKi, and Search before posting!
WoWRoster v2.1 - SigGen v0.3.3.523 - WoWRosterDF
User avatar
zanix
Admin
Admin
WoWRoster.net Dev Team
WoWRoster.net Dev Team
UA/UU Developer
UA/UU Developer
 
Posts: 5543
Joined: Mon Jul 03, 2006 8:29 am
Location: Idaho Falls, Idaho
Realm: Doomhammer (PvE) - US


Return to Uploading

Who is online

Users browsing this forum: No registered users and 0 guests

cron