Loading...
 
Features / Usability

Features / Usability


Username Pattern - Esperanto Characters (or anything else)

posts: 16 US

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

posts: 37 France

All tables should be in utf8_something. Precisely so any kind of character could be allowed.

So, your fix is good, but the puzzling thing is, how did you end up with an latin1_swedish_ci table ?


posts: 16 US

Hi, Jean-Marc,

That's a really good question. I used an app-installing meta-app called "Softlicious" that was provided as part of my website / domain at DailyRazor. And that's what it did by default.

— Kat