Username Pattern - Esperanto Characters (or anything else)
I am trying to edit the username pattern to allow for Esperanto characters (ĈĉĜĝĤĥĴĵŜŝŬŭ), which are unicode characters.
When I try to escape the codes (for example, \u015C, which is "Ŝ"), it doesn't make any difference — typing in that character results in an "Invalid character" error.
When I actually put an "Ŝ" into the username pattern field, I can type the character in, but when I actually hit the Register button, I get an error:
"Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='"
Referencing a field in one of the tables. I though I'd go ahead and let you know what the solution was, which was to go into that table in the database itself (I use phpMyAdmin at the site I'm on), find the column in particular, and change its encoding from "latin1_swedish_ci" to "utf8_general_ci".
If I'm setting myself for dramatic and ugly failure in the future, I'd appreciate a heads up, because I am no coder. : )
Thanks!
— Kat