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: 40 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


Upcoming Events

1)  18 Apr 2024 14:00 GMT-0000
Tiki Roundtable Meeting
2)  16 May 2024 14:00 GMT-0000
Tiki Roundtable Meeting
3)  20 Jun 2024 14:00 GMT-0000
Tiki Roundtable Meeting
4)  18 Jul 2024 14:00 GMT-0000
Tiki Roundtable Meeting
5)  15 Aug 2024 14:00 GMT-0000
Tiki Roundtable Meeting
6)  19 Sep 2024 14:00 GMT-0000
Tiki Roundtable Meeting
7) 
Tiki birthday
8)  17 Oct 2024 14:00 GMT-0000
Tiki Roundtable Meeting
9)  21 Nov 2024 14:00 GMT-0000
Tiki Roundtable Meeting
10)  19 Dec 2024 14:00 GMT-0000
Tiki Roundtable Meeting