I have a column called
username, i want the user to be able to insert text in japanese, roman, arabic, korean, and everything that is possible, including special chars [https://en.wiktionary.org/wiki/Index:All_languages], what
COLLATE should i set on my database and tables?
utf_general_ci, i'm new so i don't know if this is the best
COLLATE for my needs. I need to choose the right
COLLATE to avoid sql error, because i will not use
preg_replace or a function to replace special chars, i will only use
prepared statement to avoid SLQ injection and protect by database.