RSS Feed/News Preventing illegal characters in username

Status
Not open for further replies.

ENXF NET

Administrator
Staff member
Administrator
Moderator
+Lifetime VIP+
S.V.I.P.S Member
S.V.I.P Member
V.I.P Member
Collaborate
Registered
Joined
Nov 13, 2018
Messages
26,144
Points
823

Reputation:

Hello
Quite a few of our users are recently changing their usernames to usernames containing emojis and other unicode characters.
Is there a way to prevent that?

I don't really mind them using those characters, but we get server errors regarding those changes:
XF\Db\Exception: MySQL query error [1267]: Illegal mix of collations (utf8mb3_general_ci,IMPLICIT) and (utf8mb4_general_ci,COERCIBLE) for operation '='src/XF/Db/AbstractStatement.php:230

Thanks!

Edit:
I found @AndyB...

Read more

Continue reading...
 
Status
Not open for further replies.
Top