Should Usernames include emoji?

[hanakin]

Currently we do not support emoji in usernames. Is this something that we should allow if not we should add a better error msg then general sql error which is what happens when you try to register with one.

[DavidIQ]

Probably not. Also there are quite a few fields that will clunk out if you put an emoji in them. Username is one of them.

[david63]

Personally I cannot see any reason as to why you would want an emoji as part of a username and it would mean massive rewrite of the core - how would you create username_clean for example, which is used extensively. I suspect that it would cause more problems than it would solve.

If there is a genuine need for an emoji in a username then I would look at having as a separate field in the database and then appending where necessary.

[Jacob]

Emojis are not written words, so no.

[Vinny]

No.

I think would be better to focus on using emoji on topic titles, email subject or email message.

[bonelifer]

Agree with david63
+1 for what Vinny said

[3Di]

Currently we do not support emoji in usernames. Is this something that we should allow if not we should add a better error msg then general sql error which is what happens when you try to register with one.

Not in usernames please, the real matter here is to provide a meaningful error message instead of the rude SQL error indeed.

Since the username along with all the user data required for a new registration are handled by the user_add() function though, there is the place to where to start lurking at one possible solution for this, which at a first glance requires a bit to do in fact.

Another solution could be to replace the emojis entered with NOTHING or a replacement char like I did for an extension of mine. Reference: https://www.phpbb.com/community/viewtop ... &t=2422576

About Vinny's suggestion = +1 by my side as well.

[AmigoJack]

quite a few fields that will clunk out if you put an emoji in them

Why is this still an issue? Years ago I started using UTF8MB4 instead of UTF8 in MySQL5/MariaDB10 and migrated all potential text columns, and have not run into any issues so far. After all it's not about supporting Emojis, it's about (fully) supporting Unicode. Also posts with all those Unicode code points can be found by searching for them.

Personally I cannot see any reason as to why you would want an emoji as part of a username and it would mean massive rewrite of the core - how would you create username_clean for example, which is used extensively.

Up to today nobody used it on my board either - after all people also need to be able to "enter" it when logging in, and most will fail when their mind is limited to how the keyboard looks. A rewrite however is not needed, as the cleaned username is already capable of all this - it's not stripped down to ASCII only.


And while we're at it: https://www.phpbb.com/community/memberl ... &start=125 looks like things went wrong in the past, maybe errors thru migration steps.

[hubaishan]

current version 3.2.2 with postgresql support emoji in usernames