title: Keep special characters when importing into mysql from csv
body: <p>I have a csv file which contains special characters. However, when I import them into my table they do not import. I have the row that needs to contain special characters setup as utf8_general_ci</p>
  
  <p>However, I am losing the special characters upon phpmyadmin import. For example, the degree symbol is not importing. I viewed my csv file in a text editor and it does contain the special characters.</p>
  
  <p>Please help.</p>
  
  <p>Ok, I figured how to do this. See my answer below. </p>