title: Not able to fetch Unicode data in Hindi language from PHP and MySQL
body: <p>I have a database (utf8_unicode_ci), tables (utf8_unicode_ci), and a mysql_query("SET CHARACTER SET utf8").</p>
  
  <p>I have one more problem today. I have one table and in that there are 10,000 records which is stored in unicode format in the Hindi language. I am using Xampp 1.6.2 Version. When I fetch data on the local machine, it's showing properly; say for example "select * from unicode_table order by id".</p>
  
  <p>But if i upload it on my live server, it's not displaying any record. I tried to figure it out and I found that if I write:</p>
  
  <pre><code>select * from unicode_table order by id limit 0, 40
  </code></pre>
  
  <p>A query with <code>limit 0, 40</code> shows data,  and if I give <code>limit 0, 50</code> then it displays junk. So there is a problem in recordset/mysql query connection. Can any one help me out with this?</p>
  
  <p>My live server is the latest update with PHP and MySQL and the server is maintained by one of the good hosting companies.</p>
  
  <p>Thanks in advance.</p>