Dungeon Crawl Stone Soup Tracker - Mantis
Viewing Issue Advanced Details
ID: Category: Severity: Reproducibility: Date Submitted: Last Update:
3110 Bug Report minor have not tried 2010-12-31 13:00 2011-01-01 23:43
Reporter: jpeg Local or Remote:  
Assigned To: Operating System:  
Priority: normal Console or Tiles:  
Status: closed Product Branch: stable branch  
Product Version: Resolution: done  
Projection: none      
ETA: none Fixed in Branch: stable branch  
Summary: 0003110: Non-latin characters not usable in usernames/realnames
Description: 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
FROM mantis_user_table
WHERE username='Dawid Ci??arkiewicz'.

See https://crawl.develz.org/tavern/viewtopic.php?f=11&t=151 [^]
Steps To Reproduce:
Additional Information:
Relationships
Attached Files:
Issue History
Date Modified Username Field Change
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

Notes
(0010117)
Napkin   
2011-01-01 23:42   
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.