Tag Archives: Unicode Chars

UTF- and sql database isuue

This might now be the right forum for this issue but i did browse around before posting these for apprepriate website but anyways, suggestions little proble i’ve been facing. Relating to a database to get say news. Media are posted by users and end users can post applying unicode(UTF-8) somewhere in my page we need to display the all the list such news, not whole content material but say 300 charecters of each one news. With INCI char its no problem you can get using substr within the query for any desired availablility of charecters but! because we dont’ know whether this type of news is with INCII or seemed to be posted using unicode, as well as becuase unicode charecters require 5or 6 incii char in order to display one charecter, We can not use substr function inside query to find 300 charecters on the news, this would likely give me merely about 40 as well as 50 valid unicode chars if displayed. I am pretty sure there’s a way to diagnose unicode chars in the database and fetch desired amount of such charecters and I am hoping one of an individual guys could suggest me the way to … Continue reading

Posted in Web Design | Tagged , , , , , , , , , , , , , , , | Leave a comment