Viewing Issue Simple Details Jump to Notes ] Wiki ] View Advanced ] Issue History ] Print ]
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
Reporter jpeg View Status public  
Assigned To
Priority normal Resolution done  
Status closed   Product 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 [^]
Additional Information
Tags No tags attached.
Attached Files

- Relationships

-  Notes
Napkin (administrator)
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.

- 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

Mantis 1.1.8[^]
Copyright © 2000 - 2009 Mantis Group
Powered by Mantis Bugtracker