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