Page MenuHomePhabricator
Create Task
Maniphest T115

users table has swedish collation
Closed, ResolvedPublic
Actions

Description

General error: 1267 Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_unicode_ci,COERCIBLE) for operation '=' (SQL: select count(*) as aggregate from users where name = ゆい)

why is this not unicode????

Event Timeline

ceec created this task.Apr 5 2019, 11:59 PM
ceec triaged this task as High priority.
ceec created this object with visibility "Public (No Login Required)".
ceec moved this task from Backlog to Doing on the enstars.info board.
ceec closed this task as Resolved.Apr 6 2019, 1:04 PM

Switched the table collation to binary then to utf8_unicode_ci

Tested with english usernames and japanese usernames