|Anonymous | Login||2019-11-21 18:42 CET|
|Main | My View | View Issues | Change Log | Wiki | Tavern | News|
|Viewing Issue Simple Details|
|ID||Category||Severity||Reproducibility||Date Submitted||Last Update|
|0003110||[Mantis] Bug Report||minor||have not tried||2010-12-31 13:00||2011-01-01 23:43|
|Status||closed||Product Branch||stable branch|
|Summary||0003110: Non-latin characters not usable in usernames/realnames|
Database query failed. Error received from database was 0001267: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' for the query: SELECT id
WHERE username='Dawid Ci??arkiewicz'.
See https://crawl.develz.org/tavern/viewtopic.php?f=11&t=151 [^]
|Tags||No tags attached.|
Since uniqueness is checked on username & realname and because realname is not allowed to be username of any other account, I had to switch both, username & realname, from latin1_swedish_ci to utf8_general_ci.
The username is still going through a regex to allow only certain characters. I hope that's enough.
|2010-12-31 13:00||jpeg||New Issue|
|2011-01-01 23:42||Napkin||Note Added: 0010117|
|2011-01-01 23:42||Napkin||Status||new => closed|
|2011-01-01 23:42||Napkin||Resolution||open => done|
|2011-01-01 23:42||Napkin||Fixed in Branch||=> stable branch|
|2011-01-01 23:43||Napkin||Summary||Non-latin characters not usable in usernames => Non-latin characters not usable in usernames/realnames|
|Mantis 1.1.8[^] Copyright © 2000 - 2009 Mantis Group|