The forum collation (I actually have no idea what that means
) defaults to latin_swedish but his username needed at least utf8_general_ci to work. So... I had to go through and convert all of the tables.
Further more, he shouldn't have been able to create that name in the first place. It should have thrown an error (much like the one you got when PMing him). After the conversions, my ピカノ name worked and I could send / receive PMs... but his returned 'user could not be found'.
So.. I went into the DB and looked at his profile there --- his name wasn't the actual characters... but rather HTML entities which display the characters. In order to send a PM to him, you had to write something like.... #3434;#5345;#5434;... so, I just replaced his name with what it actually displays and it worked.
) defaults to latin_swedish but his username needed at least utf8_general_ci to work. So... I had to go through and convert all of the tables.Further more, he shouldn't have been able to create that name in the first place. It should have thrown an error (much like the one you got when PMing him). After the conversions, my ピカノ name worked and I could send / receive PMs... but his returned 'user could not be found'.
So.. I went into the DB and looked at his profile there --- his name wasn't the actual characters... but rather HTML entities which display the characters. In order to send a PM to him, you had to write something like.... #3434;#5345;#5434;... so, I just replaced his name with what it actually displays and it worked.
Lol. Nice.
Well, thanks Picano. You da man.












