Mysql special character

Question

I have a problem in mysql,

How can I store users' nickname like this: "" in a database?

Because for the moment it gives me: "????????????????????" in the table and I really need the real username of all users so I can rank them with the correct nicknames Thank you!

If you're getting `?` you're having UTF-8 issues. Ensure your table is `utf8mb4` as well as *all* connection settings. — tadman, Oct 26 '20 at 18:40

score -1 · Answer 1 · answered Oct 26 '20 at 18:23

-1

Store the name with HTML tags:

"" = <b><i>Morcyyyy</i></b>

answered Oct 26 '20 at 18:23

berkobienb

639
5
12

1

How does this solve any problems? It won't help with , and allowing arbitrary HTML injection in a username is how you XSS yourself. – tadman Oct 26 '20 at 18:40
Good point thanks for pointing that out – berkobienb Oct 26 '20 at 18:49

Mysql special character

1 Answers1