PHP mySQL – European Language diacritical marks

3 places to handle diacritical marks in a Eurpoean web applications

1. Set mySQL database Collation to latin1_swedish_ci
2. Set mySQL column Collation to utf8_unicode_ci
3. In PHP HTML
   <meta http-equiv=”Content_Type” content=”text/html; charset=UTF-8″/>
4. In PHP script set mysqli charset
   mysqli_set_charset($conn,”utf8″);
   $rs = mysqli_query($conn,$sql);