title: unicode and utf8 data read from database to php/html
body: <p>In my database i have a column of keywords. And in my column urdu language keywords is saved like this </p>
  
  <blockquote>
    <p>(Ø¶Ø±ÙˆØ±Øª  Ù„ÙˆÚˆØ±Ø²Ú©ÙˆÚ‘Ø§ Ú©Ø±Ú©Ù¹ Ø§Ù¹Ú¾Ø§Ù†...)</p>
  </blockquote>
  
  <p>but when i display it in php. It gives me correct urdu keywords. </p>
  
  <p>Today i imported more keywords from an ods format file now in my column keywords are saved like this</p>
  
  <blockquote>
    <p>(پلاٹ پلاٹس کنال مرلہ مرلے کنال ٹاپ سٹی خریدوفروخت ...)</p>
  </blockquote>
  
  <p>so in order to display ods file keywords i have to run this query </p>
  
  <pre><code>mysql_query ("set character_set_results='utf8'"); 
  </code></pre>
  
  <p>From this query ods data display correctly but above not and when i run this query</p>
  
  <pre><code>mysql_query ("set character_set_results='unicode'"); 
  </code></pre>
  
  <p>above data print correctly but below not.</p>