title: How can I limit unicode characters from database?
body: <p>I have my native language store in mysql database look like this</p>
  
  <blockquote>
    <p>កីឡាករ​រក​ចំណូល​បាន​ខ្ពស់​​បំផុត​មួយ​នៅ​លើ​លោក ដោយ​រក​បាន​ជិត​១​លាន​ផោន</p>
  </blockquote>
  
  <p>but I want to limit it only 100 characters to show and if more than 100 show ...</p>
  
  <p>I use this code</p>
  
  <blockquote>
    <p>echo substr($row[1],0,100).((strlen($row[1])>100)? '...' : '');</p>
  </blockquote>
  
  <p>It works well if the data in database is English characters,but for my native 
  language character it doesn't work. In database i set </p>
  
  <blockquote>
    <p>Type = text, Collation = utf8_general_ci  </p>
  </blockquote>